private void ConfirmButton_Click(object sender, EventArgs e)
{
OrderBackLogController orderBackLogController = new OrderBackLogController();
OrderBackLog orderBackLog = new OrderBackLog();
if (DiscountComboBox.Text.Length == 0 || VatComboBox.Text.Length == 0)
{
MessageBox.Show("Please fill properly ...");
}
else
{
double discount = Double.Parse(DiscountComboBox.Text);
double vat = Double.Parse(VatComboBox.Text);
double totalPrice = (Price - discount) + (((Price - discount) * vat) / 100);
//MessageBox.Show(vat.ToString()+discount.ToString()+ Price.ToString() + totalPrice.ToString());
//new added
orderBackLog.Price = Price.ToString();
orderBackLog.Discount = discount.ToString();
orderBackLog.Vat = vat.ToString();
orderBackLog.TotalPrice = totalPrice.ToString();
orderBackLogController.insertOrderBackLog(orderBackLog);
//new added
Voucher voucher = new Voucher(Price, discount, vat, totalPrice);
voucher.Show();
this.Visible = false;
}
}
public bool insertOrderBackLog(OrderBackLog orderBackLog)
{
try
{
string connectionString = GetConnection();
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
string query = @"insert into OrderBackLog (Price,Discount,Vat,TotalPrice) values('" + orderBackLog.Price + "','" + orderBackLog.Discount + "','" + orderBackLog.Vat + "','" + orderBackLog.TotalPrice + "')";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
if (sqlCommand.ExecuteNonQuery() == 1)
{
sqlConnection.Close();
return(true);
}
else
{
sqlConnection.Close();
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
