public void getCustomer(long CustomerID) { ddlcutomer.Items.Clear(); iStatutoryMasterClient StatutoryClient = new iStatutoryMasterClient(); CustomProfile profile = CustomProfile.GetProfile(); ddlcutomer.DataSource = StatutoryClient.GetCustomerList(CustomerID, profile.DBConnection._constr); ddlcutomer.DataTextField = "Name"; ddlcutomer.DataValueField = "ID"; ddlcutomer.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddlcutomer.Items.Insert(0, lst); StatutoryClient.Close(); }
public static List <contact> GetDepartment(object objReq) { iStatutoryMasterClient StatutoryClient = new iStatutoryMasterClient(); CustomProfile profile = CustomProfile.GetProfile(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); List <contact> LocList = new List <contact>(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objReq; long ddlcompanyId = long.Parse(dictionary["ddlcompanyId"].ToString()); ds = StatutoryClient.GetCustomerList(ddlcompanyId, profile.DBConnection._constr); dt = ds.Tables[0]; contact Loc = new contact(); Loc.Name = "--Select--"; Loc.Id = "0"; LocList.Add(Loc); Loc = new contact(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Loc.Id = dt.Rows[i]["ID"].ToString(); Loc.Name = dt.Rows[i]["Name"].ToString(); LocList.Add(Loc); Loc = new contact(); } } } catch { } finally { StatutoryClient.Close(); } return(LocList); }