public int UpdateOrInsertRoom(tbl_Room obj)
{
using (var db = _connectionData.OpenDbConnection())
{
if (obj.Id > 0)
{
var query = db.From <tbl_Room>().Where(e => e.Id == obj.Id);
var objUpdate = db.Select(query).SingleOrDefault();
if (objUpdate != null)
{
//bjUpdate.Code = obj.Code;
objUpdate.Name = obj.Name;
objUpdate.Floor = obj.Floor;
objUpdate.RoomType_ID = obj.RoomType_ID;
return(db.Update(objUpdate));
}
return(-1);
}
else
{
var queryCount = db.From <tbl_Room>().Where(e => e.Name == obj.Name && e.SysHotelID == comm.GetHotelId()).Select(e => e.Id);
var objCount = db.Count(queryCount);
if (objCount > 0)
{
return(comm.ERROR_EXIST);
}
obj.SysHotelID = comm.GetHotelId();
//obj.RoomType_ID = obj.RoomType_ID;
return((int)db.Insert(obj, selectIdentity: true));
}
}
}
public List <HotelRoomVM> CreateHotelsAndRooms(List <HotelRoomVM> hotelRooms)
{
using (var db = new HotelManagementDbEntities())
{
tbl_Hotel hotel = new tbl_Hotel();
tbl_Room room = new tbl_Room();
var mapper = ModelMapping.MappingConfig();
foreach (var hotelRoom in hotelRooms)
{
hotel = mapper.Map <HotelRoomVM, tbl_Hotel>(hotelRoom);
db.tbl_Hotel.Add(hotel);
db.SaveChanges();
foreach (var rooms in hotelRoom.Rooms)
{
rooms.HotelId = hotel.HotelId;
room = mapper.Map <Room, tbl_Room>(rooms);
db.tbl_Room.Add(room);
db.SaveChanges();
}
}
hotelRooms.ForEach(x => x.HotelId = hotel.HotelId);
hotelRooms.ForEach(x => x.Rooms.ForEach(p => p.RoomId = room.RoomId));
return(hotelRooms);
}
}
public tbl_Room InitEmpty()
{
var obj = new tbl_Room();
obj.Id = 0;
obj.Name = "";
obj.Floor = "1";
return(obj);
}
public PartialViewResult Edit(string id)
{
tbl_Room obj = (new RoomService()).GetRoomByID(id);
if (obj == null)
{
obj = (new RoomService()).InitEmpty();
}
return(PartialView("EditRoom", obj));
}
public void Add(RoomModel model)
{
using (HMSEntities dbContext = new HMSEntities())
{
tbl_Room entity = new tbl_Room();
entity.HotWater = model.HotWater;
entity.IsAvailable = model.IsAvailable;
entity.RoomNumber = model.RoomNumber;
entity.RoomType = model.RoomType;
entity.Towel = model.Towel;
entity.TV = model.TV;
entity.Price = model.Price;
dbContext.tbl_Room.Add(entity);
dbContext.SaveChanges();
}
}
public ActionResult Update(tbl_Room obj)
{
int result = new RoomService().UpdateOrInsertRoom(obj);
return Json(new { result = result }, JsonRequestBehavior.AllowGet);
}
