nordic96/wsdev_proj

WebService Project

Hi there, I'm Stephen 👋

I'm Stephen, a computer science graduate from NUS, Singapore. I am currently working as a Frontend Developer, and I am very excited to pursue my career in Frontend Engineering!

• 🔭 I’m currently working on Frontend Development
• 🌱 I’m currently learning ReactJS, Typescript, Redux, and many more!
• 👯 I’m looking to collaborate on Establishing a structured testing environment for React based UI applications

Stats Overview

Language Used Overview

wsdev_proj's Issues

Implement Autocomplete ComboBox using AJAX toolkit

will replace search textboxes of SeaPortSearch.aspx & Freight.aspx with AJAX autocomplete combobox.

Freight.aspx Local Address Search nextpage & prevpage button not working

showing current page number and total page number but not loading the next/prev page results in the gridview.

Duties.aspx currency converted label only show $ & value showing more than 2 decimals.

Total Price : S$ 7600
Currency Convertion: KRW
Converted Price : $6276611.6155768176000975074656 (Displaying $ sign, not KRW)

@DsGodh

1. Converted price must display selected currency type
2. Converted value must be 2 decimals.

Adding Freight Forwarders gridview and search methods

@DsGodh
searching freight forwarders list into the Freight.aspx required. later will also have to replace with AJAX autocomplete combobox.

Replace excel read & search methods to use EPPlus library instead

Return SeaPortSearch gives error when no row is selected.

Plz fix.

Currency External WS in Duties.aspx not loading

suggest for AJAX loading
suggest update progress template something like this.

<asp:UpdateProgress ID="UpdateProgress1" runat="server"> <ProgressTemplate> Loading...<img src="../Content/loading-icon.gif" style="width:70px;height:50px;"/> </ProgressTemplate> </asp:UpdateProgress>

SearchFreightForwarders() also creating unnecessary columns

<xs:element name="Column12" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column13" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column14" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column15" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column16" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column17" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column18" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column19" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column20" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column21" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column22" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column23" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column24" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="Column25" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/>

@DsGodh needs a validation method to prevent.

GetAllFreightForwarders() creating unnecessary columns

<xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="FreightForwarder"> <xs:complexType> <xs:sequence> <xs:element name="Country" type="xs:string" minOccurs="0"/> <xs:element name="Company_x0020_Name" type="xs:string" minOccurs="0"/> <xs:element name="Tel_x0020_Number" type="xs:string" minOccurs="0"/> <xs:element name="Emergency_x0020_Tel" type="xs:string" minOccurs="0"/> <xs:element name="Fax_x0020_Number" type="xs:string" minOccurs="0"/> <xs:element name="Email" type="xs:string" minOccurs="0"/> <xs:element name="Contact_x0020_Names" type="xs:string" minOccurs="0"/> <xs:element name="Website" type="xs:string" minOccurs="0"/> <xs:element name="MSN" type="xs:string" minOccurs="0"/> <xs:element name="SKYPE" type="xs:string" minOccurs="0"/> <xs:element name="Address" type="xs:string" minOccurs="0"/> <xs:element name="NOTES" type="xs:string" minOccurs="0"/> <xs:element name="A12" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="A13" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/> <xs:element name="A14" msdata:DataType="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:anyType" minOccurs="0"/>
.
.
.
@DsGodh unnecessary columns creating from A12 onwards,

Freight.aspx gvFreightForwarderContacts not displaying

search btn also not working.

Duties.aspx needs additional design changes

@DsGodh use h2 for the title, add any logo image if can (Singapore Customs logo, can refer to my other pages). And try to remove any unnecessary codes or files on your side. #10

Search Functions Not working

System.InvalidCastException: Unable to cast object of type 'System.Double' to type 'System.String'.
at System.Data.DataRowExtensions.UnboxT1.ReferenceField(Object value) at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName) at LogisticsService.<>c__DisplayClass11_0.<ExcelSearchData_EP>b__0(DataRow port) in C:\Users\jacky\Documents\Visual Studio 2015\WebSites\WS_Project\WSDEV_PROJ\App_Code\LogisticsService.cs:line 484 at System.Linq.Enumerable.WhereEnumerableIterator1.MoveNext()
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)
at LogisticsService.ExcelSearchData_EP(String url, Int32 row_to_start, String search_by, String search_text) in C:\Users\jacky\Documents\Visual Studio 2015\WebSites\WS_Project\WSDEV_PROJ\App_Code\LogisticsService.cs:line 488
at LogisticsService.SearchHsCode(String searchBy, String searchText) in C:\Users\jacky\Documents\Visual Studio 2015\WebSites\WS_Project\WSDEV_PROJ\App_Code\LogisticsService.cs:line 556

FreightForward Country drop down list showing repeat values

@DsGodh country drop down list contains repeating country names.