private void button9_Click(object sender, EventArgs e) { try { string date = DateTime.Now.ToString("dd/MM/yyyy"); DateTime d = DateTime.ParseExact(date, "dd/MM/yyyy", CultureInfo.InvariantCulture); string dd = d.ToString("yyyy/MM/dd"); if (label41.Text == richTextBox8.Text) { db.sql.Close(); db.sql.Open(); SqlCommand cmd2 = new SqlCommand("update medicine_selling_history set paid='" + richTextBox6.Text + "',due='0' where inv_id='" + label39.Text + "'", db.sql); SqlCommand cmdddd = new SqlCommand("insert into user_cash_collection_pharmacy(user_name,password,reg_no,name,paid,date,date2) values('" + user_name + "','" + password + "','" + label39.Text + "','" + pharmacy_due_name + "','" + richTextBox8.Text + "','" + date + "','" + dd + "')", db.sql); cmdddd.ExecuteNonQuery(); int a = cmd2.ExecuteNonQuery(); if (a > 0) { MessageBox.Show("Bill Taken Sucessfull"); Pharmacy_Due_Print pd = new Pharmacy_Due_Print(label39.Text, richTextBox8.Text, user_name); pd.Show(); show_due(); } } else { MessageBox.Show("You have to pay all Due amount"); } } catch { } }
/* Get Paid Button Click */ private void button9_Click(object sender, EventArgs e) { try { double total = Convert.ToDouble(label41.Text); string date1 = dataGridView3.SelectedRows[0].Cells[10].Value.ToString(); string date2 = dateTimePicker2.Text; string date = DateTime.Now.ToString("dd/MM/yyyy"); DateTime d = DateTime.ParseExact(date, "dd/MM/yyyy", CultureInfo.InvariantCulture); string dd = d.ToString("yyyy/MM/dd"); if (label41.Text == richTextBox8.Text) { if (total > 0) { double now_paing = Convert.ToDouble(richTextBox8.Text); double total_paid = now_paing + already_paid; db.sql.Close(); db.sql.Open(); SqlCommand cmd2 = new SqlCommand("update medicine_selling_history set paid='" + total_paid + "',due='0' where inv_id='" + label39.Text + "'", db.sql); SqlCommand cmdddd = new SqlCommand("insert into user_cash_collection_pharmacy(user_name,password,reg_no,name,paid,date,date2) values('" + user_name + "','" + password + "','" + label39.Text + "','" + pharmacy_due_name + "','" + richTextBox8.Text + "','" + date + "','" + dd + "')", db.sql); SqlCommand cmddd = new SqlCommand("update user_cash_collection_pharmacy set paid='" + total_paid + "' where reg_no='" + label39.Text + "'", db.sql); if (date1 == date2) { cmddd.ExecuteNonQuery(); } else { cmdddd.ExecuteNonQuery(); } int a = cmd2.ExecuteNonQuery(); if (a > 0) { MessageBox.Show("Bill Taken Sucessfull"); Pharmacy_Due_Print pd = new Pharmacy_Due_Print(label39.Text, richTextBox8.Text, user_name); pd.Show(); show_due(); label39.Text = ""; label41.Text = ""; richTextBox8.Clear(); } } else { MessageBox.Show("Choose a due amount"); } } else { MessageBox.Show("You have to pay all Due amount"); } } catch { } }