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);
}
public RoomResultViewModel GetAllRooms()
{
var result = new RoomResultViewModel();
List <RoomViewModel> roomList = GetRoomDetails();
result.Room = new RoomViewModel();
result.RoomList = roomList;
return(result);
}
public RoomResultViewModel SaveRoomDetails(RoomViewModel roomVm)
{
var result = new RoomResultViewModel();
if (GetRoomById(roomVm.RoomId))
{
result = UpdateRoom(roomVm);
}
else
{
result = CreateRoom(roomVm);
}
return(result);
}
