public void lbtnCopyRooms_Clicked(object sender, EventArgs e)
{
LinkButton lbtnCopyRooms = (LinkButton)sender;
Guid retreatId = new Guid(lbtnCopyRooms.Attributes["retreatid"]);
Monks.jkp_Retreat retreat = db.jkp_Retreats.First(p => p.Ret_ID == retreatId);
List<Monks.jkp_Hamlet> newHamlets = new List<Monks.jkp_Hamlet>();
List<Monks.jkp_Building> newBuildings = new List<Monks.jkp_Building>();
List<Monks.jkp_Room> newRooms = new List<Monks.jkp_Room>();
List<Monks.jkp_RoomRate> newRoomRates = new List<Monks.jkp_RoomRate>();
foreach (Monks.jkp_Hamlet hamletInRetreat in retreat.jkp_Site.jkp_Hamlets)
{
Monks.jkp_Hamlet newHamlet = new Monks.jkp_Hamlet();
newHamlet.Ham_Add_ID = hamletInRetreat.Ham_Add_ID;
newHamlet.Ham_Comment = hamletInRetreat.Ham_Comment;
newHamlet.Ham_Description = hamletInRetreat.Ham_Description;
newHamlet.Ham_ID = Guid.NewGuid();
newHamlet.Ham_LocalName = hamletInRetreat.Ham_LocalName;
newHamlet.Ham_Site_ID = retreat.Ret_Site_ID;
newHamlet.Ham_VietnameseName = hamletInRetreat.Ham_VietnameseName;
newHamlet.Ham_EnglishName = hamletInRetreat.Ham_EnglishName;
newHamlets.Add(newHamlet);
foreach (Monks.jkp_Building building in hamletInRetreat.jkp_Buildings)
{
Monks.jkp_Building newBuilding = new Monks.jkp_Building();
newBuilding.Bld_Comment = building.Bld_Comment;
newBuilding.Bld_Description = building.Bld_Description;
newBuilding.Bld_Directions = building.Bld_Directions;
newBuilding.Bld_EnglishName = building.Bld_EnglishName;
newBuilding.Bld_Ham_ID = newHamlet.Ham_ID;
newBuilding.Bld_ID = Guid.NewGuid();
newBuilding.Bld_LocalName = building.Bld_LocalName;
newBuilding.Bld_VietnameseName = building.Bld_VietnameseName;
newBuildings.Add(newBuilding);
foreach (Monks.jkp_Room room in building.jkp_Rooms)
{
Monks.jkp_Room newRoom = new Monks.jkp_Room();
newRoom.Rm_Bld_ID = newBuilding.Bld_ID;
newRoom.Rm_Comment = room.Rm_Comment;
newRoom.Rm_ID = Guid.NewGuid();
newRoom.Rm_Level = room.Rm_Level;
newRoom.Rm_Name = room.Rm_Name;
newRoom.Rm_RmType_ID = room.Rm_RmType_ID;
newRoom.Rm_TotalCapacity = room.Rm_TotalCapacity;
newRooms.Add(newRoom);
foreach (Monks.jkp_RoomRate roomRate in room.jkp_RoomRates)
{
Monks.jkp_RoomRate newRoomRate = new Monks.jkp_RoomRate();
newRoomRate.RR_EndDate = roomRate.RR_EndDate;
newRoomRate.RR_StartDate = roomRate.RR_StartDate;
newRoomRate.RR_Rm_ID = newRoom.Rm_ID;
newRoomRate.RR_Rt_ID = roomRate.RR_Rt_ID;
newRoomRates.Add(newRoomRate);
}
}
}
}
db.jkp_Hamlets.InsertAllOnSubmit(newHamlets);
db.jkp_Buildings.InsertAllOnSubmit(newBuildings);
db.jkp_Rooms.InsertAllOnSubmit(newRooms);
db.jkp_RoomRates.InsertAllOnSubmit(newRoomRates);
db.SubmitChanges();
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues);
LoadRetreatsFromSelectedSite();
mvCopy.ActiveViewIndex = 1;
}
private void detach_jkp_Rooms(jkp_Room entity)
{
this.SendPropertyChanging();
entity.jkp_RoomType = null;
}
public void btnCreateRoom_Clicked(object sender, EventArgs e)
{
MonkData db = new MonkData();
Guid buildingId = new Guid(dlBuildings.SelectedValue);
// Check to see if there are any rooms with this same name already on the building.
var roomsWithSameNameInBuilding = from r in db.jkp_Rooms
where r.Rm_Bld_ID == buildingId && r.Rm_Name == txtCreateRoomsName.Text.Trim().ToUpper()
select r;
if(roomsWithSameNameInBuilding.Count() > 0)
return; // Duplicate room found.
Monks.jkp_Room room = new Monks.jkp_Room();
room.Rm_Bld_ID = buildingId;
room.Rm_ID = Guid.NewGuid();
if (!String.IsNullOrEmpty(txtCreateRoomLevelNumber.Text))
room.Rm_Level = int.Parse(txtCreateRoomLevelNumber.Text);
room.Rm_Name = txtCreateRoomsName.Text.Trim().ToUpper();
room.Rm_RmType_ID = new Guid( dlRoomType.SelectedValue);
room.Rm_TotalCapacity = int.Parse(txtCreateRoomCapacity.Text);
room.Rm_ContructedDate = DateTime.Parse(txtCreateRoomConstructionDate.Text);
if(!String.IsNullOrEmpty(txtCreateRoomDestructionDate.Text))
room.Rm_DestroyedDate = DateTime.Parse(txtCreateRoomDestructionDate.Text);
db.jkp_Rooms.InsertOnSubmit(room);
db.SubmitChanges();
RedrawRoomsForRetreat(db);
txtCreateRoomsName.Text = "";
modalRoom.Hide();
}
private void attach_jkp_Rooms(jkp_Room entity)
{
this.SendPropertyChanging();
entity.jkp_RoomType = this;
}