public bool UpdateTable(CaffeTable caffeTable)
{
int result = this.tableRepository.UpdateTable(caffeTable);
if (result != 0)
{
return(true);
}
else
{
return(false);
}
}
public int InsertCaffeTable(CaffeTable caffeTable)
{
int result;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandText = $"Insert into Tables(Table_ID, Worker_ID, Number_Of_Seats, Taken) values({caffeTable.Table_ID},{caffeTable.Worker_ID},{caffeTable.Number_Of_Seats},'{caffeTable.Taken}')";
result = sqlCommand.ExecuteNonQuery();
}
return(result);
}
private void B_Click(object sender, EventArgs e)
{
BillBusiness b11 = new BillBusiness();
Button b1 = sender as Button;
TableBusiness tb = new TableBusiness();
CaffeTable t = tb.getCaffeTables().Where(x => x.Table_ID == (Convert.ToInt32(b1.ID))).ToList()[0];
tb.UpdateTable(t);
BillBusiness.currentBill = b11.getCaffeBills().Where(x => x.Paid == false && t.Table_ID == x.Table_ID).ToList()[0];
TableBusiness.curentTable = t;
Response.Redirect("Bill.aspx");
}
public int UpdateTable(CaffeTable caffeTable)
{
int result;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandText = "Update Tables SET Worker_ID =@workerID, Number_Of_Seats = @numberOfSeats, Taken=@take where Table_ID = @tableID";
sqlCommand.Parameters.AddWithValue("@workerID", caffeTable.Worker_ID);
sqlCommand.Parameters.AddWithValue("@numberOfSeats", caffeTable.Number_Of_Seats);
sqlCommand.Parameters.AddWithValue("@take", caffeTable.Taken);
sqlCommand.Parameters.AddWithValue("@tableID", caffeTable.Table_ID);
result = sqlCommand.ExecuteNonQuery();
}
return(result);
}
private void button13_Click(object sender, EventArgs e)
{
BillBusiness b11 = new BillBusiness();
TableBusiness tb = new TableBusiness();
CaffeTable t = tb.getCaffeTables().Where(x => x.Table_ID == Convert.ToInt32(button13.Text)).ToList()[0];
TableBusiness.curentTable = t;
t.Taken = true;
tb.UpdateTable(t);
try
{
BillBusiness.currentBill = b11.getCaffeBills().Where(x => x.Paid == false && t.Table_ID == x.Table_ID).ToList()[0];
}
catch (Exception ex)
{
b11.InsertCaffeBill(new CaffeBill(999, t.Table_ID, 0, DateTime.Now, false));
BillBusiness.currentBill = b11.getCaffeBills().Where(x => x.Paid == false && t.Table_ID == x.Table_ID).ToList()[0];
}
Bill b = new Bill();
b.Show();
}
private void B1_Click(object sender, EventArgs e)
{
BillBusiness b11 = new BillBusiness();
Button b1 = sender as Button;
TableBusiness tb = new TableBusiness();
CaffeTable t = tb.getCaffeTables().Where(x => x.Table_ID == (Convert.ToInt32(b1.ID) - 99)).ToList()[0];
t.Taken = true;
tb.UpdateTable(t);
try
{
BillBusiness.currentBill = b11.getCaffeBills().Where(x => x.Paid == false && t.Table_ID == x.Table_ID).ToList()[0];
}
catch (Exception ex)
{
b11.InsertCaffeBill(new CaffeBill(999, (Convert.ToInt32(b1.ID) - 99), 0, DateTime.Now, false));
BillBusiness.currentBill = b11.getCaffeBills().Where(x => x.Paid == false && t.Table_ID == x.Table_ID).ToList()[0];
}
t.Table_ID = Convert.ToInt32(b1.CommandArgument);
TableBusiness.curentTable = t;
Response.Redirect("Bill.aspx");
}
public void init()
{
t = new CaffeTable(17, 1, 4, false);
tr = new TableRepository();
}
