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
{
}
}
