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();
}
}
}
}
