public static List<CheckOutBill> loadCheckOutBillData(string sql ,string WaiterName)
{
List<CheckOutBill> list = new List<CheckOutBill>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, new SqlParameter("@WaiterName", WaiterName)))
{
if (reader.HasRows)
{
while (reader.Read())
{
CheckOutBill room = new CheckOutBill();
room.BillNumber = reader.GetGuid(0);
room.RoomNumber = reader.GetString(1);
room.GuestName = reader.GetString(2);
room.NumberOfPeaple = reader.GetString(3);
room.RoomRate = reader.GetDecimal(4);
room.ConsumptionPaid = reader.GetDecimal(5);
room.Date = reader.GetDateTime(6);
room.WaiterName = reader.GetString(7);
list.Add(room);
}
}
}
return list;
}
public static void addCheckOutBill(CheckOutBill checkOutBill)
{
SqlParameter[] pams = new SqlParameter[]
{
new SqlParameter ("@Id",checkOutBill.Id ),
new SqlParameter ("@BillNumber",checkOutBill.BillNumber),
new SqlParameter ("@RoomNumber",checkOutBill.RoomNumber ),
new SqlParameter ("@GuestName",checkOutBill.GuestName ),
new SqlParameter ("@NumberOfPeaple",checkOutBill.NumberOfPeaple ),
new SqlParameter ("@RoomRate",checkOutBill.RoomRate ),
new SqlParameter ("@ConsumptionPaid",checkOutBill.ConsumptionPaid ),
new SqlParameter ("@Date",checkOutBill.Date ),
new SqlParameter ("@WaiterName",checkOutBill.WaiterName ),
new SqlParameter ("@CheckInBillTableId",checkOutBill.CheckInBillTableId ),
};
SqlHelper.ExecuteNonQuery(AddCheckOutBillDAL.sql, pams);
}
public static void addCheckOutBill(CheckOutBill checkOutBill)
{
AddCheckOutBillDAL.addCheckOutBill(checkOutBill);
}
