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";
}
}
