//seach
private void dgw_MouseClick(object sender, MouseEventArgs e)
{
try
{
if (lblOperation.Text == "Sales")
{
DataGridViewRow dr = dgw.SelectedRows[0];
this.Hide();
//frmPatientMedicineBilling frm = new frmPatientMedicineBilling();
CustomerBilling frm = new CustomerBilling();
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();
//search method
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 hallCustomerMealBillingToolStripMenuItem_Click(object sender, EventArgs e)
{
CustomerBilling mBill = new CustomerBilling();
mBill.Show();
}
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();
Customer_Entry frm = new Customer_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();
CustomerBilling frm = new CustomerBilling();
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);
}
}
