private void SAVE_Click(object sender, EventArgs e)
{
if (Bill_No.Text == "" || Party_ID.Text == "" || AOC.Text == "" || Ac_No.Text == "" || Ch_No.Text == "" || DOW.Text == "" || Bank_Name.Text == "")
{
MessageBox.Show("PLEASE_FILLUP _ALL_DATA!!!");
Bill_No.Focus();
}
else
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO Bill_Payment(Bill_No,Party_ID,Amount_Of_Check,Account_No,Check_No,Date_Of_Withdrawn,Bank_Name,Date)VALUES('" + Bill_No.Text + "','" + Party_ID.Text + "','" + AOC.Text + "','" + Ac_No.Text + "','" + Ch_No.Text + "','" + DOW.Text + "','" + Bank_Name.Text + "','" + Date.Text + "')", con);
sda.SelectCommand.ExecuteNonQuery();
con.Close();
Bill_No.Text = "";
Party_ID.Text = "";
AOC.Text = "";
Ac_No.Text = "";
Ch_No.Text = "";
DOW.Text = "";
Bank_Name.Text = "";
Date.Text = "";
Bill_No.Focus();
MessageBox.Show("SAVED_SUCCESSFULLY");
}
}
private void CLEAR_Click(object sender, EventArgs e)
{
Bill_No.Text = "";
Party_ID.Text = "";
Bill_No.Focus();
MessageBox.Show("ALL_CLEARED__!!!");
}
private void UPDATE_Click(object sender, EventArgs e)
{
if (Total_Amount.Text == "" || Advance_Amount.Text == "" || Balance_Amount.Text == "")
{
MessageBox.Show("PLZ_FILL_RECOMMENDED_DATA__!!!");
}
else
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("UPDATE Billing_Detail SET Total_Amount='" + Total_Amount.Text + "',Advance_Amount='" + Advance_Amount.Text + "',Balance_Amount='" + Balance_Amount.Text + "' WHERE Bill_NO='" + Bill_No.Text + "'", con);
sda.SelectCommand.ExecuteNonQuery();
con.Close();
Bill_No.Text = "";
Vehicle_ID.Text = "";
Party_ID.Text = "";
DOL.Text = "";
POL.Text = "";
POU.Text = "";
WIM.Text = "";
RPM.Text = "";
Total_Amount.Text = "";
Advance_Amount.Text = "";
Balance_Amount.Text = "";
Bill_Status.Text = "";
Material_Desc.Text = "";
Date.Text = "";
Bill_No.Focus();
MessageBox.Show("UPDATE_SUCCESSFULLY!!!");
}
}
private void CLEAR_Click(object sender, EventArgs e)
{
Bill_No.Text = "";
Party_ID.Text = "";
AOC.Text = "";
Ac_No.Text = "";
Ch_NO.Text = "";
DOW.Text = "";
Bank_Name.Text = "";
Date.Text = "";
Bill_No.Focus();
MessageBox.Show("ALL_CLEARED--!!!");
}
private void DELETE_Click(object sender, EventArgs e)
{
if (Bill_No.Text == "" || Party_ID.Text == "")
{
MessageBox.Show("PLEASE_FILL_ALL_RECOMMENDED_DATA_FIRST_!!");
}
else
{
con.Open();
SqlCommand scd = new SqlCommand("DELETE FROM Bill_Payment WHERE Bill_No='" + Bill_No.Text + "' and Party_ID='" + Party_ID.Text + "'", con);
scd.ExecuteNonQuery();
con.Close();
Bill_No.Text = "";
Party_ID.Text = "";
Bill_No.Focus();
MessageBox.Show("DELETE__SUCCESSFULLY__!!!");
}
}
private void SAVE_Click(object sender, EventArgs e)
{
if (Bill_No.Text == "" || Vehicle_ID.Text == "" || Party_ID.Text == "" || DOL.Text == "" || POL.Text == "" || POU.Text == "" || WIM.Text == "" || RPM.Text == "" || Total_Amount.Text == "" || Advance_Amount.Text == "" || Balance_Amount.Text == "" || Bill_Status.Text == "" || Material_Desc.Text == "" || Date.Text == "")
{
MessageBox.Show("PLEASE_FILL_ALL_DATA");
Bill_No.Focus();
}
else
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("INSERT INTO Billing_Detail(Bill_No,Vehicle_ID,Party_ID,Date_Of_Loading,Place_Of_Loading,Place_Of_Unloading,Weight_In_Matrictone,Rate_Per_Matrictone,Total_Amount,Advance_Amount,Balance_Amount,Bill_Status,Material_Description,Date)VALUES('" + Bill_No.Text + "','" + Vehicle_ID.Text + "','" + Party_ID.Text + "','" + DOL.Text + "','" + POL.Text + "','" + POU.Text + "','" + WIM.Text + "','" + RPM.Text + "','" + Total_Amount.Text + "','" + Advance_Amount.Text + "','" + Balance_Amount.Text + "','" + Bill_Status.Text + "','" + Material_Desc.Text + "','" + Date.Text + "')", con);
sda.SelectCommand.ExecuteNonQuery();
con.Close();
Bill_No.Text = "";
Vehicle_ID.Text = "";
Party_ID.Text = "";
DOL.Text = "";
POL.Text = "";
POU.Text = "";
WIM.Text = "";
RPM.Text = "";
Total_Amount.Text = "";
Advance_Amount.Text = "";
Balance_Amount.Text = "";
Bill_Status.Text = "";
Material_Desc.Text = "";
Date.Text = "";
Bill_No.Focus();
MessageBox.Show("SAVED SUCCESSFULLY!!!");
Add_Billing_Detail_Form ds = new Add_Billing_Detail_Form();
this.Dispose(false);
ds.Show();
}
}
private void CLEAR_Click(object sender, EventArgs e)
{
Bill_No.Text = "";
Vehicle_ID.Text = "";
Party_ID.Text = "";
DOL.Text = "";
POL.Text = "";
POU.Text = "";
WIM.Text = "";
RPM.Text = "";
Total_Amount.Text = "";
Advance_Amount.Text = "";
Balance_Amount.Text = "";
Bill_Status.Text = "";
Material_Desc.Text = "";
Date.Text = "";
Bill_No.Focus();
MessageBox.Show("CLEAR_SUCCESSFULLY!!!");
}
private void UPDATE_Click(object sender, EventArgs e)
{
if (AOC.Text == "" || Ch_NO.Text == "")
{
MessageBox.Show("PLEASE_ENTER_RECOMMENDED_DATA__!!!");
}
else
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("UPDATE Bill_Payment SET Amount_Of_Check='" + AOC.Text + "',Check_No='" + Ch_NO.Text + "' WHERE Bill_No='" + Bill_No.Text + "'", con);
sda.SelectCommand.ExecuteNonQuery();
con.Close();
Bill_No.Text = "";
Party_ID.Text = "";
AOC.Text = "";
Ac_No.Text = "";
Ch_NO.Text = "";
DOW.Text = "";
Bank_Name.Text = "";
Date.Text = "";
Bill_No.Focus();
MessageBox.Show("Data_Updated!!");
}
}
