private void dgw_MouseClick(object sender, MouseEventArgs e) { try { if (lblOperation.Text == "Sales") { DataGridViewRow dr = dgw.SelectedRows[0]; this.Hide(); //frmPatientMedicineBilling frm = new frmPatientMedicineBilling(); StudentMealBilling frm = new StudentMealBilling(); frm.Show(); frm.txtID.Text = dr.Cells[0].Value.ToString(); frm.txtBillNo.Text = dr.Cells[1].Value.ToString(); frm.dtpBillDate.Text = dr.Cells[2].Value.ToString(); frm.txtC_Id.Text = dr.Cells[3].Value.ToString(); frm.txtCustomerID.Text = dr.Cells[4].Value.ToString(); frm.txtCustomerName.Text = dr.Cells[5].Value.ToString(); frm.txtGrandTotal.Text = dr.Cells[6].Value.ToString(); frm.txtCash.Text = dr.Cells[7].Value.ToString(); frm.txtChange.Text = dr.Cells[8].Value.ToString(); frm.btnUpdate.Enabled = true; frm.btnDelete.Enabled = true; frm.btnSave.Enabled = false; frm.lblUser.Text = lblUser.Text; lblOperation.Text = ""; cc.con = new SqlConnection(cs.DBConn); cc.con.Open(); cc.cmd = new SqlCommand("SELECT RTRIM(ProductSold.ProductID),RTRIM(ProductName),RTRIM(ProductSold.Price),RTRIM(Quantity),RTRIM(Amount),RTRIM(DiscountPer), RTRIM(DiscountAmount), RTRIM(STPer), RTRIM(STAmount), RTRIM(VATPer), RTRIM(VATAmount),RTRIM(TotalAmount) from Product,OrderedProduct,ProductSold where Product.P_ID=ProductSold.ProductID and Orderedproduct.B_ID=ProductSold.BillID and BillNo='" + dr.Cells[1].Value + "'", cc.con); cc.rdr = cc.cmd.ExecuteReader(CommandBehavior.CloseConnection); frm.DataGridView1.Rows.Clear(); while (cc.rdr.Read() == true) { frm.DataGridView1.Rows.Add(cc.rdr[0], cc.rdr[1], cc.rdr[2], cc.rdr[3], cc.rdr[4], cc.rdr[5], cc.rdr[6], cc.rdr[7], cc.rdr[8], cc.rdr[9], cc.rdr[10]); } cc.con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void dgw_MouseClick(object sender, MouseEventArgs e) { try { if (lblOperation.Text == "Customer Master") { DataGridViewRow dr = dgw.SelectedRows[0]; this.Hide(); //frmPatient frm = new frmPatient(); Student_Entry frm = new Student_Entry(); frm.Show(); frm.txtID.Text = dr.Cells[0].Value.ToString(); frm.txtCustomerID.Text = dr.Cells[1].Value.ToString(); frm.txtCustomerName.Text = dr.Cells[2].Value.ToString(); frm.txtAddress.Text = dr.Cells[3].Value.ToString(); frm.txtCity.Text = dr.Cells[4].Value.ToString(); frm.txtContactNo.Text = dr.Cells[5].Value.ToString(); frm.txtEmailID.Text = dr.Cells[6].Value.ToString(); byte[] data = (byte[])dr.Cells[7].Value; MemoryStream ms = new MemoryStream(data); frm.Picture.Image = Image.FromStream(ms); frm.btnUpdate.Enabled = true; frm.btnDelete.Enabled = true; frm.btnSave.Enabled = false; frm.lblUser.Text = lblUser.Text; lblOperation.Text = ""; } /* if (lblOperation.Text == "Membership") * { * DataGridViewRow dr = dgw.SelectedRows[0]; * this.Hide(); * frmAdmittedPatientStayBilling frm = new frmAdmittedPatientStayBilling(); * frm.Show(); * frm.txtM_ID.Text = dr.Cells[0].Value.ToString(); * frm.txtMemberName.Text = dr.Cells[2].Value.ToString(); * frm.txtAddress.Text = dr.Cells[3].Value.ToString(); * frm.txtCity.Text = dr.Cells[4].Value.ToString(); * frm.txtContactNo.Text = dr.Cells[5].Value.ToString(); * frm.txtEmailID.Text = dr.Cells[6].Value.ToString(); * byte[] data = (byte[])dr.Cells[7].Value; * MemoryStream ms = new MemoryStream(data); * frm.Picture.Image = Image.FromStream(ms); * frm.lblUser.Text = lblUser.Text; * lblOperation.Text = ""; * frm.auto(); * * } */ if (lblOperation.Text == "Sales") { DataGridViewRow dr = dgw.SelectedRows[0]; this.Hide(); StudentMealBilling frm = new StudentMealBilling(); frm.Show(); frm.txtC_Id.Text = dr.Cells[0].Value.ToString(); frm.txtCustomerID.Text = dr.Cells[1].Value.ToString(); frm.txtCustomerName.Text = dr.Cells[2].Value.ToString(); frm.lblUser.Text = lblUser.Text; lblOperation.Text = ""; frm.auto(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void hallStudentMealBillingToolStripMenuItem_Click(object sender, EventArgs e) { StudentMealBilling mBill = new StudentMealBilling(); mBill.Show(); }