public void loadAllPakagesCustomers() { try { DataTable getaallpakages = bllmess.getallPakagesLists(); if (getaallpakages.Rows.Count > 0) { dgv_customers.Rows.Clear(); for (int i = 0; i < getaallpakages.Rows.Count; i++) { DataTable getallcustomer = bllcus.getallcustomersbyPakages(getaallpakages.Rows[i]["name"].ToString()); if (getallcustomer.Rows.Count > 0) { for (int j = 0; j < getallcustomer.Rows.Count; j++) { dgv_customers.Rows.Add(getallcustomer.Rows[j]["id"].ToString(), getallcustomer.Rows[j]["name"].ToString(), getallcustomer.Rows[j]["lastname"].ToString(), getallcustomer.Rows[j]["gender"].ToString(), getallcustomer.Rows[j]["pakage_name"].ToString()); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void loadAllPakagesCustomers() { DataTable getaallpakages = bllmess.getallPakagesLists(); if (getaallpakages.Rows.Count > 0) { dgv_customers.Rows.Clear(); for (int i = 0; i < getaallpakages.Rows.Count; i++) { DataTable getallcustomer = bllcus.getallcustomersbyPakages(getaallpakages.Rows[i]["name"].ToString()); if (getallcustomer.Rows.Count > 0) { for (int j = 0; j < getallcustomer.Rows.Count; j++) { dgv_customers.Rows.Add(getallcustomer.Rows[j]["id"].ToString(), (byte[])getallcustomer.Rows[j]["image"], getallcustomer.Rows[j]["name"].ToString(), getallcustomer.Rows[j]["lastname"].ToString(), getallcustomer.Rows[j]["gender"].ToString(), getallcustomer.Rows[j]["pakage_name"].ToString(), getallcustomer.Rows[j]["address"].ToString(), getallcustomer.Rows[j]["phone"].ToString(), getallcustomer.Rows[j]["phone2"].ToString(), getallcustomer.Rows[j]["startingDate"].ToString(), getallcustomer.Rows[j]["noofdays"].ToString()); } } } } }
public void getallPakages() { dataGridView1.Rows.Clear(); DataTable dtst = Bllmess.getallPakagesLists(); if (dtst.Rows.Count > 0) { for (int i = 0; i < dtst.Rows.Count; i++) { dataGridView1.Rows.Add("", dtst.Rows[i]["pg_id"].ToString(), dtst.Rows[i]["name"].ToString(), dtst.Rows[i]["price"].ToString(), dtst.Rows[i]["details"].ToString()); } } }
public void loaddallpakageslist() { bll_customer_mess Bllmess = new bll_customer_mess(); DataTable getpakage = Bllmess.getallPakagesLists(); if (getpakage.Rows.Count > 0) { DataRow dr = getpakage.NewRow(); dr["name"] = "Choose Package"; getpakage.Rows.InsertAt(dr, 0); cbo_packagename.DataSource = getpakage; cbo_packagename.DisplayMember = "name"; } }