private void coustomerListToolStripMenuItem_Click(object sender, EventArgs e) { foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(frm_customer_list)) { form.Activate(); return; } } frm_customer_list fcl = new frm_customer_list(); fcl.MdiParent = this; fcl.Show(); }
private void button1_Click(object sender, EventArgs e) { using (var partyList = new frm_customer_list("partystatement")) { var partyForm = partyList.ShowDialog(); if (partyList.DialogResult == DialogResult.OK) { textBox2.Text = partyList.returnPartyName; textBox1.Text = partyList.returnPartyId; if (textBox1.Text != "") { mycon(); cmd = new SqlCommand("select * from getpartybottlecount Where party_id in (select party_id from tbl_party where _party_id=@pid)", con); cmd.Parameters.AddWithValue("@pid", textBox1.Text); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; if (dt.Rows.Count > 0) { int sum = Convert.ToInt32(dt.Compute("SUM(count)", string.Empty)); label2.Text = sum.ToString(); con.Close(); mycon(); cmd = new SqlCommand("select party_name from tbl_party where _party_id=@pid", con); cmd.Parameters.AddWithValue("@pid", textBox1.Text); dr = cmd.ExecuteReader(); while (dr.Read()) { textBox2.Text = dr[0].ToString(); } con.Close(); cmd.Dispose(); } } } } }
private void button1_Click(object sender, EventArgs e) { using (var partyList = new frm_customer_list("partybymonthchalan")) { var partyForm = partyList.ShowDialog(); if (partyList.DialogResult == DialogResult.OK) { textBox1.Text = partyList.returnPartyName; textBox2.Text = partyList.returnPartyId; if (textBox1.Text != "") { mycon(); cmd = new SqlCommand("SELECT * FROM getchalanstatement WHERE (MONTH(sales_date) = MONTH(@date)) AND (YEAR(sales_date) = YEAR(@date)) AND (_party_id = @pid)", con); cmd.Parameters.AddWithValue("@pid", textBox2.Text); cmd.Parameters.AddWithValue("@date", dateTimePicker1.Value); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; } } } }
private void button2_Click(object sender, EventArgs e) { using (var partyList = new frm_customer_list("GanarateSales")) { var partyForm = partyList.ShowDialog(); if (partyList.DialogResult == DialogResult.OK) { textBox1.Text = partyList.returnPartyName; txtpartycode.Text = partyList.returnPartyId; if (textBox1.Text != "") { mycon(); cmd = new SqlCommand("select party_id from tbl_party where _party_id=@pn", con); cmd.Parameters.AddWithValue("@pn", partyList.returnPartyId); dr = cmd.ExecuteReader(); if (dr.Read()) { lblPartyId.Text = dr[0].ToString(); } con.Close(); } } } }