private RoomResultViewModel UpdateRoom(RoomViewModel roomVm)
{
var result = new RoomResultViewModel();
List <RoomViewModel> roomList = null;
try
{
string roomInsQuery = string.Format("UPDATE tblr_room SET room_desc={0},room_type={1},room_floor={2},updated_by={3},updated_on={4},isactive={5}", roomVm.Description, roomVm.SelectedRoomType, roomVm.RoomFloor, 1, DateTime.Now, 1);
int val = DbConnetClass.setData(roomInsQuery);
if (val > 0)
{
result.IsSuccess = true;
result.Message = "Room is saved successfully";
}
roomList = GetRoomDetails();
result.RoomList = roomList;
}
catch (Exception)
{
throw;
}
return(result);
}
private RoomResultViewModel CreateRoom(RoomViewModel roomVm)
{
var result = new RoomResultViewModel();
List <RoomViewModel> roomList = null;
try
{
string roomInsQuery = string.Format("INSERT INTO tblr_room VALUES({0},'{1}','{2}','{3}',{4} ,{5},'{6}','{7}',{8},{9})", roomVm.RoomId, roomVm.Description, roomVm.SelectedRoomType, roomVm.RoomFloor, 1, 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), 1, roomVm.RoomRate);
int val = DbConnetClass.setData(roomInsQuery);
if (val > 0)
{
result.IsSuccess = true;
result.Message = "Room is saved successfully";
}
roomList = GetRoomDetails();
result.Room = new RoomViewModel();
result.RoomList = roomList;
}
catch (Exception)
{
throw;
}
return(result);
}
private RoomResultReservationOrderViewModel CreateReservationOrder(RoomReservationOrderViewModel order)
{
var reservationResult = new RoomResultReservationOrderViewModel();
try
{
string insertGuestInfo = string.Format("INSERT INTO tblt_resheader VALUES({0},'{1}','{2}','{3}','{4}' ,'{5}',{6},{7},'{8}','{9}',{10},'{11}','{12}')", order.ResNo, order.Title, order.FirstName, order.LastName, order.Address, order.ContactNo, 1, 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), 1, order.CheckInDate.ToString("yyyy-MM-dd HH:mm:ss"), order.CheckInDate.ToString("yyyy-MM-dd HH:mm:ss"));
int val = DbConnetClass.setData(insertGuestInfo);
if (val > 0)
{
order.selectedRooms.ForEach(t =>
{
string insertRoomReseDetails = string.Format("INSERT INTO tblt_resdet VALUES({0},{1},{2},'{3}',{4} ,{5},'{6}','{7}',{8})", order.ResNo, t.RoomId, t.RoomRate, "LKR", 1, 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), 1);
DbConnetClass.setData(insertRoomReseDetails);
});
reservationResult.IsSuccess = true;
reservationResult.Message = "Reservation is saved successfully";
}
}
catch (Exception ex)
{
}
return(reservationResult);
}
private RoomResultReservationOrderViewModel UpdateReservationOrder(RoomReservationOrderViewModel order)
{
var reservationResult = new RoomResultReservationOrderViewModel();
try
{
string insertGuestInfo = string.Format("UPDATE tblt_resheader SET Cus_title='{0}',Cus_FName='{1}',Cus_LName='{2}',Cus_Addr='{3}',Cus_Cont='{4}' ,updated_by={5},updated_on={6},isactive={7} WHERE Res_no = '" + order.ResNo + "'", order.Title, order.FirstName, order.LastName, order.Address, order.ContactNo, 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), 1);
int val = DbConnetClass.setData(insertGuestInfo);
if (val > 0)
{
order.roolListVm.ForEach(t =>
{
string getOrderDetails = "SELECT * FROM tblt_resdet WHERE Res_no = '" + order.ResNo + "' AND Room_no = '" + t.RoomId + "'";
MySqlDataReader orderReader = DbConnetClass.getData(getOrderDetails);
if (!orderReader.HasRows)
{
string insertRoomReseDetails = string.Format("INSERT INTO tblt_resdet VALUES({0},{1},{2},'{3}',{4} ,{5},'{6}','{7}',{8})", order.ResNo, t.RoomId, t.RoomRate, "LKR", 1, 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), 1);
DbConnetClass.setData(insertRoomReseDetails);
}
else
{
if (t.IsRemoved)
{
string deleteRoomReserved = "DELETE FROM tblt_resdet WHERE WHERE Res_no = '" + order.ResNo + "' AND Room_no = '" + t.RoomId + "'";
DbConnetClass.setData(deleteRoomReserved);
}
}
});
reservationResult.IsSuccess = true;
reservationResult.Message = "Reservation is saved successfully";
}
}
catch (Exception ex)
{
}
return(reservationResult);
}
