private void button1_Click_1(object sender, EventArgs e)
{
try
{
discharge_bill db = new discharge_bill(richTextBox1.Text, label8.Text);
db.Show();
}
catch
{
}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
int exe = 0;
int id = 0;;
string val1 = "";
string val2 = "";
string val3 = "";
string val4 = "";
int n = 0;
int c = dataGridView2.Rows.Count;
db.sql.Close();
db.sql.Open();
for (n = 0; n <= c - 1; n++)
{
val3 = dataGridView2.Rows[n].Cells[2].Value.ToString();
val4 = dataGridView2.Rows[n].Cells[3].Value.ToString();
SqlCommand cmd = new SqlCommand("update patient_bill set bill='" + val3 + "' where reg_no='" + richTextBox1.Text + "' and bill_id='" + val4 + "'", db.sql);
exe = cmd.ExecuteNonQuery();
}
db.sql.Close();
}
catch
{
}
try
{
int aa = Convert.ToInt32(label15.Text);
int b = Convert.ToInt32(richTextBox5.Text);
if (richTextBox5.Text == "")
{
MessageBox.Show("Give a valid amount");
}
else
{
if (b != aa)
{
MessageBox.Show("You have to pay the current due amount");
}
else
{
string date = dateTimePicker1.Text;
DateTime d = DateTime.ParseExact(date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
string dd = d.ToString("yyyy/MM/dd");
db.sql.Close();
db.sql.Open();
SqlCommand cmd2 = new SqlCommand("delete from discharge_bill where reg_no='" + richTextBox1.Text + "'", db.sql);
cmd2.ExecuteNonQuery();
db.sql.Close();
db.sql.Open();
SqlCommand cmd = new SqlCommand("insert into discharge_bill(reg_no,total,discount,paid,date,date2)values('" + richTextBox1.Text + "','" + label13.Text + "','" + richTextBox9.Text + "','" + richTextBox5.Text + "','" + date + "','" + dd + "')", db.sql);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
MessageBox.Show("Bill taken Sucessfully");
discharge_bill dbb = new discharge_bill(richTextBox1.Text, label8.Text);
dbb.Show();
}
else
{
MessageBox.Show("Not Paid");
}
db.sql.Close();
}
}
}
catch
{
}
}