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); }