private void btn_save_Click(object sender, EventArgs e) { decimal a; if (txt_pakagename.Text == "" || txt_pakageDetails.Text == "" || txt_price.Text == "") { MessageBox.Show("Please Fill Requird inputs."); } else if (!decimal.TryParse(txt_price.Text, out a)) { MessageBox.Show("Price Name must be Numeric."); } else { DataTable getPakageName = Bllmess.CheckExistedPakagename(txt_pakagename.Text); if (getPakageName.Rows.Count > 0) { MessageBox.Show("Pakage Name Already Exists"); } else { int pakages = Bllmess.insertintomessPakage(txt_pakagename.Text, Convert.ToDecimal(txt_price.Text), txt_pakageDetails.Text); if (pakages > 0) { pakageName = txt_pakagename.Text; this.DialogResult = DialogResult.OK; MessageBox.Show("Pakage Created"); getallPakages(); this.Hide(); } } } }
private void lbl_cusId_TextChanged(object sender, EventArgs e) { DataTable forbreakfast = blf.getallBreakfastsbyUserid(lbl_cusId.Text); if (forbreakfast.Rows.Count > 0) { for (int i = 0; i < forbreakfast.Rows.Count; i++) { dgv_br.Rows.Add(forbreakfast.Rows[i]["customer_ID"].ToString(), forbreakfast.Rows[i]["dates"].ToString(), forbreakfast.Rows[i]["day"].ToString(), forbreakfast.Rows[i]["package_name"].ToString()); } } DataTable forlunch = blf.getallLunchbyUserid(lbl_cusId.Text); if (forlunch.Rows.Count > 0) { for (int i = 0; i < forlunch.Rows.Count; i++) { dgv_lunch.Rows.Add(forlunch.Rows[i]["customer_ID"].ToString(), forlunch.Rows[i]["dates"].ToString(), forlunch.Rows[i]["day"].ToString(), forlunch.Rows[i]["package_name"].ToString()); } } DataTable forsnacks = blf.getallsnacksbyUserid(lbl_cusId.Text); if (forsnacks.Rows.Count > 0) { for (int i = 0; i < forsnacks.Rows.Count; i++) { dgv_snacks.Rows.Add(forsnacks.Rows[i]["customer_ID"].ToString(), forsnacks.Rows[i]["dates"].ToString(), forsnacks.Rows[i]["day"].ToString(), forsnacks.Rows[i]["package_name"].ToString()); } } DataTable forDinner = blf.getallDinnerbyUserid(lbl_cusId.Text); if (forDinner.Rows.Count > 0) { for (int i = 0; i < forDinner.Rows.Count; i++) { dgv_dinner.Rows.Add(forDinner.Rows[i]["customer_ID"].ToString(), forDinner.Rows[i]["dates"].ToString(), forDinner.Rows[i]["day"].ToString(), forDinner.Rows[i]["package_name"].ToString()); } } DataTable forextrapayales = bcr.getallMessrecordbyUserid(lbl_cusId.Text); if (forextrapayales.Rows.Count > 0) { for (int i = 0; i < forextrapayales.Rows.Count; i++) { String dddt = Convert.ToDateTime(forextrapayales.Rows[i]["dates"].ToString()).ToShortDateString(); dgv_extras.Rows.Add(forextrapayales.Rows[i]["cus_id"].ToString(), forextrapayales.Rows[i]["package"].ToString(), dddt, forextrapayales.Rows[i]["day"].ToString(), forextrapayales.Rows[i]["description"].ToString(), forextrapayales.Rows[i]["atetime"].ToString(), forextrapayales.Rows[i]["amount"].ToString()); } } DataTable getpacakage = bcm.CheckExistedPakagename(lbl_packages.Text); if (getpacakage.Rows.Count > 0) { lbl_packageCost.Text = getpacakage.Rows[0]["price"].ToString(); } addupdatagridviewcols(); lbl_totalamount.Text = ((Convert.ToDecimal(lbl_packageCost.Text) * Convert.ToInt32(lbl_noofdays.Text)) + Convert.ToDecimal(lbl_sum.Text)).ToString(); }