public static BookingModel GetBookingModel(int bookingid)
{
BookingModel bk = null;
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
string sql = "SELECT * FROM dbo.Booking WHERE BookingID = @bookingid";
SqlCommand cm = new SqlCommand(sql, conn);
cm.Parameters.AddWithValue("@bookingid", bookingid);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
bk = new BookingModel();
bk.BookingID = rs[0] as int? ?? 0;
bk.Guest = GuestDAO.GetGuest(rs[1] as int? ?? 0);
bk.Room = RoomsDAO.GetRoomModel(rs[2] as int? ?? 0);
bk.BookingDate = rs[3] as DateTime? ?? DateTime.MinValue;
bk.CancelDate = rs[4] as DateTime? ?? DateTime.MinValue;
bk.CheckInDate = rs[5] as DateTime? ?? DateTime.MinValue;
bk.CheckOutDate = rs[6] as DateTime? ?? DateTime.MinValue;
bk.Payment = PaymentDAO.GetPayment(rs[7] as int? ?? 0);
bk.Deposit = rs[8] as int? ?? 0;
bk.Amount = rs[9] as int? ?? 0;
bk.Status = rs[10] as string;
}
}
}
}
return(bk);
}
public static bool InsertRoom(Room room)
{
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
if (!RoomsDAO.CheckIsExistRoomById(room.RoomID))
{
string sql = "INSERT INTO Room(RoomID,RoomTypeID,Status) VALUES(@roomid,@roomtypeid,@status)";
SqlCommand cm = new SqlCommand(sql, conn);
cm.Parameters.AddWithValue("@roomid", room.RoomID);
cm.Parameters.AddWithValue("@roomtypeid", room.RoomTypeID);
cm.Parameters.AddWithValue("@status", room.Status);
cm.ExecuteNonQuery();
return(true);
}
}
}
return(false);
}
public static List <BookingModel> GetBookingsViewModel(DateTime fromdate, DateTime todate)
{
List <BookingModel> list = new List <BookingModel>();
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
string sql = "SELECT * FROM dbo.Booking WHERE CheckOutDate >= @fromdate and CheckInDate <= @todate";
SqlCommand cm = new SqlCommand(sql, conn);
cm.Parameters.AddWithValue("@fromdate", fromdate);
cm.Parameters.AddWithValue("@todate", todate);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
BookingModel bk = new BookingModel();
bk.BookingID = rs[0] as int? ?? 0;
bk.Guest = GuestDAO.GetGuest(rs[1] as int? ?? 0);
bk.Room = RoomsDAO.GetRoomModel(rs[2] as int? ?? 0);
bk.BookingDate = rs[3] as DateTime? ?? DateTime.MinValue;
bk.CancelDate = rs[4] as DateTime? ?? DateTime.MinValue;
bk.CheckInDate = rs[5] as DateTime? ?? DateTime.MinValue;
bk.CheckOutDate = rs[6] as DateTime? ?? DateTime.MinValue;
bk.Payment = PaymentDAO.GetPayment(rs[7] as int? ?? 0);
bk.Deposit = rs[8] as int? ?? 0;
bk.Amount = rs[9] as int? ?? 0;
bk.Status = rs[10] as string;
list.Add(bk);
}
}
}
}
return(list);
}
