public void DeleteCaffeBillsTest() { bir.InsertCaffeBill(cb); CaffeBill c = bir.GetCaffeBills().Where(x => x.Total_Price == cb.Total_Price).ToList()[0]; int result = bir.DeleteCaffeBill(c.Bill_ID); bir.InsertCaffeBill(cb); Assert.IsTrue(result > 0); }
public void UpdateCaffeBillsTest() { bir.InsertCaffeBill(cb); CaffeBill c = bir.GetCaffeBills().Where(x => x.Total_Price == cb.Total_Price).ToList()[0]; c.Paid = false; int result = bir.UpdateCaffeBill(c); Assert.IsTrue(result > 0); }
public bool UpdateCaffeBill(CaffeBill caffeBill) { int result = this.billRepository.UpdateCaffeBill(caffeBill); if (result != 0) { return(true); } else { return(false); } }
public int InsertCaffeBill(CaffeBill caffeBill) { int result; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; caffeBill.Date_And_Time = DateTime.Now; sqlCommand.CommandText = $"Insert into Bills( Table_ID, Total_Price, Date_And_Time, Paid) values({caffeBill.Table_ID},{caffeBill.Total_Price},'{caffeBill.Date_And_Time.ToString("MM/dd/yyyy HH:mm:ss")}',0)"; result = sqlCommand.ExecuteNonQuery(); } return(result); }
public int UpdateCaffeBill(CaffeBill caffeBill) { int result; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = "Update Bills SET Table_ID =@tableID, Total_Price = @totalPrice, Date_And_Time = @dateAndTime, Paid = @Paid where Bill_ID = @billID"; sqlCommand.Parameters.AddWithValue("@tableID", caffeBill.Table_ID); sqlCommand.Parameters.AddWithValue("@totalPrice", caffeBill.Total_Price); sqlCommand.Parameters.AddWithValue("@dateAndTime", caffeBill.Date_And_Time); sqlCommand.Parameters.AddWithValue("@billID", caffeBill.Bill_ID); sqlCommand.Parameters.AddWithValue("@Paid", caffeBill.Paid); result = sqlCommand.ExecuteNonQuery(); } return(result); }
public void clean() { CaffeBill c = bir.GetCaffeBills().Where(x => x.Total_Price == cb.Total_Price).ToList()[0]; bir.DeleteCaffeBill(c.Bill_ID); }
public void init() { cb = new CaffeBill(9999, 1, 98765, DateTime.Now, true); bir = new BillRepository(); }