public Result update(DTO_BILL_INFO bill_in)
{
String query = "UPDATE [BILL_INFO] ";
query += "SET [ID_FOD] = @ID_FOD ";
query += "SET [ID_BIL] = @ID_BIL ";
query += "SET [COUNT] = @COUNT ";
query += "SET [PRICE] = @PRICE ";
query += "WHERE [ID_BILF] = @ID_BILF";
SqlCommand cmmd = new SqlCommand();
cmmd.Connection = conn;
cmmd.CommandType = System.Data.CommandType.Text;
cmmd.CommandText = query;
cmmd.Parameters.AddWithValue("@ID_BILF", bill_in.ID);
cmmd.Parameters.AddWithValue("@ID_FOD", bill_in.ID_FOD);
cmmd.Parameters.AddWithValue("@ID_BIL", bill_in.ID_BIL);
cmmd.Parameters.AddWithValue("@COUNT", bill_in.COUNT);
cmmd.Parameters.AddWithValue("@PRICE", bill_in.PRICE);
try
{
conn.Open();
cmmd.ExecuteNonQuery();
}
catch (Exception e)
{
conn.Close();
System.Console.WriteLine(e.Message);
return(new Result(false, e.Message));
}
conn.Close();
return(new Result(true));
}
public Result insert(DTO_BILL_INFO bill_in)
{
String query = "INSERT INTO [BILL_INFO] ([ID_BILF], [ID_FOD], [ID_BIL], [COUNT], [PRICE]) ";
query += "VALUES (@ID_BILF, @ID_FOD, @ID_BIL, @COUNT, @PRICE)";
SqlCommand cmmd = new SqlCommand();
cmmd.Connection = conn;
cmmd.CommandType = System.Data.CommandType.Text;
cmmd.CommandText = query;
cmmd.Parameters.AddWithValue("@ID_BILF", bill_in.ID);
cmmd.Parameters.AddWithValue("@ID_FOD", bill_in.ID_FOD);
cmmd.Parameters.AddWithValue("@ID_BIL", bill_in.ID_BIL);
cmmd.Parameters.AddWithValue("@COUNT", bill_in.COUNT);
cmmd.Parameters.AddWithValue("@PRICE", bill_in.PRICE);
try
{
conn.Open();
cmmd.ExecuteNonQuery();
}
catch (Exception e)
{
conn.Close();
System.Console.WriteLine(e.Message);
return(new Result(false, e.Message));
}
conn.Close();
return(new Result(true));
}
private void btn_submit_Click(object sender, EventArgs e)
{
if (ntd_price.Value == 0)
{
MessageBox.Show("Don't input price!");
}
else
{
List <DTO_BILL_INFO> temp = list_in;
Double sum_price = 0, subprice = 0;
Double custom_price = Convert.ToDouble(ntd_price.Value);
if (temp.Count() != 0)
{
foreach (DTO_BILL_INFO item in temp)
{
sum_price += item.PRICE;
//insert bill infor
String id_info = bus_infoBill.nextID();
DTO_BILL_INFO temp_bill_info = new DTO_BILL_INFO(id_info, item.ID_FOD, item.ID_BIL, item.COUNT, item.PRICE);
bus_infoBill.insert(temp_bill_info);
}
subprice = custom_price - sum_price;
//insert bill
DTO_BILL bill = new DTO_BILL(lb_ID.Text, dtp_time.Value, "U02", lb_id_table.Text, "DONE", sum_price, subprice);
Result result = bus_bill.insert(bill);
//insert bill info
lst_bill.Items.Clear();
lb_sum.Text = sum_price.ToString();
lb_sub.Text = subprice.ToString();
btn_add.Enabled = false;
btn_order.Enabled = false;
btn_submit.Enabled = false;
btn_reset.Enabled = false;
}
else
{
MessageBox.Show("You must add food for bill");
}
}
}
public Result insert(DTO_BILL_INFO bill_in)
{
return(dal_bill_in.insert(bill_in));
}
