public int UpdateOrInsertHotel(tbl_Hotel obj)
{
using (var db = _connectionData.OpenDbConnection())
{
if (obj.Id > 0)
{
var query = db.From <tbl_Hotel>().Where(e => e.Id == obj.Id);
var objUpdate = db.Select(query).SingleOrDefault();
if (objUpdate != null)
{
objUpdate.Address = obj.Address;
//objUpdate.Code = obj.Code;
objUpdate.Name = obj.Name;
objUpdate.Code = obj.Code;
objUpdate.Address = obj.Address;
objUpdate.Email = obj.Email;
objUpdate.Mobile = obj.Mobile;
objUpdate.Phone = obj.Phone;
return(db.Update(objUpdate));
}
return(-1);
}
else
{
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_Hotel InitEmpty()
{
var obj = new tbl_Hotel();
obj.Id = 0;
obj.Address = "";
obj.Code = "";
obj.Name = "";
obj.Mobile = "";
obj.Phone = "";
obj.Email = "";
return(obj);
}
