private void button1_Click(object sender, EventArgs e)
{
string check_product_name;
newCon Check_p_name = new newCon(Logon.Log, Logon.Password);
check_product_name = Check_p_name.Check_Product_Name(ref p_name);
if (p_name == check_product_name)
{
int final_amount;
newCon Check_amount = new newCon(Logon.Log, Logon.Password);
check_p_amount = Check_amount.Check_Amount(ref p_name);
final_amount = check_p_amount + p_amount;
newCon Update_amount = new newCon(Logon.Log, Logon.Password);
Update_amount.Amount_Update(final_amount, p_name);
try
{
newCon Add_expiration_date = new newCon(Logon.Log, Logon.Password);
Add_expiration_date.INTO_EXP_DATE(p_name, Serial_num, Expiration_date);
}
catch
{
MessageBox.Show("Error data format.");
}
}
else
{
MessageBox.Show("Add this product to database.");
}
MessageBox.Show("Delivery Success");
}
private void End_Sale_Click(object sender, EventArgs e)
{
int Cus_ID, Invoice_ID;
newCon Check_Cus_ID = new newCon(Logon.Log, Logon.Password);
Cus_ID = Check_Cus_ID.GetID(ref Cus_name);
newCon Check_Invoice_ID = new newCon(Logon.Log, Logon.Password);
Invoice_ID = Check_Invoice_ID.Get_Invoice_ID();
Invoice_ID += 1;
newCon Check_Discount = new newCon(Logon.Log, Logon.Password);
Discount = Check_Discount.Get_Discount(ref Cus_name);
newCon Check_Employee_ID = new newCon(Logon.Log, Logon.Password);
Employee_ID = Check_Employee_ID.Get_Employee_ID(ref Logon.Log);
sum_with_discount = sum - (sum * (Discount / 100));
newCon Add2 = new newCon(Logon.Log, Logon.Password);
Add2.INTO_INV_HEAD(Cus_ID, sum_with_discount, payment, Discount);
newCon Add1 = new newCon(Logon.Log, Logon.Password);
Add1.INTO_SALE(Employee_ID, Cus_name, Invoice_ID);
foreach (ListViewItem lvi in listView1.Items)
{
P_name = lvi.SubItems[1].Text;
P_amount = lvi.SubItems[2].Text;
P_price = Convert.ToInt32(lvi.SubItems[3].Text);
unit_of_measurement = lvi.SubItems[4].Text;
serial_number = lvi.SubItems[5].Text;
exp_date = lvi.SubItems[6].Text;
newCon Add3 = new newCon(Logon.Log, Logon.Password);
Add3.INTO_INV_ITEMS(P_name, Invoice_ID, Convert.ToInt32(P_amount), unit_of_measurement, P_price, P_bar_code);
newCon GetAmount = new newCon(Logon.Log, Logon.Password);
Amount_base = GetAmount.Check_Amount(ref P_name);
residual = Amount_base - Convert.ToInt32(P_amount);
newCon Update1 = new newCon(Logon.Log, Logon.Password);
Update1.Amount_Update(residual, P_name);
}
this.Close();
}
