public bool CreatePremise(Premise pre, PremiseDetail detail, PermiseDetailForCost cost, PremiseOpenSchedule open)
{
try
{
_db.Premises.InsertOnSubmit(pre);
_db.SubmitChanges();
detail.PremiseID = pre.PremiseID;
cost.PermiseID = pre.PremiseID;
open.PremiseID = pre.PremiseID;
_db.PremiseDetails.InsertOnSubmit(detail);
_db.PermiseDetailForCosts.InsertOnSubmit(cost);
_db.PremiseOpenSchedules.InsertOnSubmit(open);
_db.SubmitChanges();
return true;
}
catch
{
return false;
}
}
//
// GET: /Premise/OpeningTimes/PremiseID
public ViewResult OpeningTimes(string StartMonday, string EndMonday,
string StartTuesday, string EndTuesday, string StartWednesday, string EndWednesday,
string StartThursday, string EndThursday, string StartFriday, string EndFriday,
string StartSaturday, string EndSaturday, string StartSunday, string EndSunday,
string CheckMonday, string CheckTuesday, string CheckWednesday, string CheckThursday,
string CheckFriday, string CheckSaturday, string CheckSunday)
{
var model = new PremiseOpenSchedule();
model.StartMonday = StartMonday; ViewBag.Monday = CheckMonday;
model.EndMonday = EndMonday;
model.StartTuesday = StartTuesday; ViewBag.Tuesday = CheckTuesday;
model.EndTuesday = EndTuesday;
model.StartWednesday = StartWednesday; ViewBag.Wednesday = CheckWednesday;
model.EndWednesday = EndWednesday;
model.StartThursday = StartThursday; ViewBag.Thursday = CheckThursday;
model.EndThursday = EndThursday;
model.StartFriday = StartFriday; ViewBag.Friday = CheckFriday;
model.EndFriday = EndFriday;
model.StartSaturday = StartSaturday; ViewBag.Saturday = CheckSaturday;
model.EndSaturday = EndSaturday;
model.StartSunday = StartSunday; ViewBag.Sunday = CheckSunday;
model.EndSunday = EndSunday;
return View(model);
}
public PartialViewResult Add(string LocationName, string LocationStatus, string PremisePhone, int? CountryID,
int? LocationOrganisation, int? MediaContact, int? CateringContact, int? CateringType, int? VisitorParkingSpace,
int? HostingContact, int? NoOfMeetingRooms, int? PreferredStatus, int? Codings,
FormCollection collection)
{
Premise pre = new Premise();
pre.LocationName = LocationName;
pre.PrimaryLocation = collection["PrimaryLocation"] == "1" ? 1 : 0;
pre.KnownAS = collection["KnownAS"];
pre.LocationManaged = collection["LocationManaged"] == "1" ? 1 : 0;
pre.LocationStatus = LocationStatus;
pre.RefListID = "," + collection["LocationType[]"] + ",";
pre.LocationStatusDate = _db.ConvertDate(collection["LocationStatusDate"], "dd/MM/yyyy");
pre.PremiseAddr1 = collection["PremiseAddr1"];
pre.PremiseAddr2 = collection["PremiseAddr2"];
pre.PremiseAddr3 = collection["PremiseAddr3"];
pre.LocationDescription = collection["LocationDescription"];
pre.PremisePostCode = collection["PostCode"];
pre.CityTown = collection["CityTown"];
pre.PremisePhone = PremisePhone;
pre.County = collection["County"];
pre.PremisFax = collection["PremisFax"];
pre.CountryID = CountryID;
pre.PremisMinicomn = collection["PremisMinicomn"];
pre.PremiseIsNew = collection["PremiseIsNew"] == "1" ? 1 : 0;
pre.PremiseShopFlagDate = _db.ConvertDate(collection["PremiseShopFlagDate"], "dd/MM/yyyy");
pre.PremiseSpecialistShop = collection["PremiseSpecialistShop"] == "1" ? 1 : 0;
pre.LocationOrganisation = LocationOrganisation;
pre.PremiseIsActive = 1;
var detail = new PremiseDetail();
detail.RefListID = "," + collection["RefListID[]"] + ",";
detail.MediaContactCheck = collection["MediaContactCheck"] == "1" ? 1 : 0;
detail.CateringFacilities = collection["CateringFacilities"] == "1" ? 1 : 0;
detail.MediaContact = MediaContact;
detail.CateringContact = CateringContact;
detail.CateringType = CateringType;
detail.ClientITFacilities = collection["ClientITFacilities"] == "1" ? 1 : 0;
detail.LocalDemographicNote = collection["LocalDemographicNote"];
detail.MediaContactCheck = collection["MediaContactCheck"] == "1" ? 1 : 0;
detail.ClientITFacilitiesDetail = collection["ClientITFacilitiesDetail"];
detail.RoomAvailability = collection["RoomAvailability"] == "1" ? 1 : 0;
detail.VolunteeringOpportunuties = collection["VolunteeringOpportunuties"] == "1" ? 1 : 0;
detail.PremiseOutreachLocationListID = "," + collection["PremiseOutreachLocationListID[]"] + ",";
detail.PremiseLocalHotelListID = "," + collection["PremiseLocalHotelListID[]"] + ",";
detail.TravelDetail = collection["TravelDetail"];
detail.VisitorParkingOnsite = collection["VisitorParkingOnsite"] == "1" ? 1 : 0;
detail.TravelNearestBus = collection["TravelNearestBus"];
detail.VisitorParkingSpace = VisitorParkingSpace;
detail.TravelNearestRail = collection["TravelNearestRail"];
detail.VisitorParkingAlternative = collection["VisitorParkingAlternative"];
detail.TravelNearestAirport = collection["TravelNearestAirport"];
detail.HostVisits = collection["HostVisits"] == "1" ? 1 : 0;
detail.HostingContact = HostingContact;
detail.TravelNearestAirport = collection["TravelNearestAirport"];
var cost = new PermiseDetailForCost();
cost.RoomOnlyRate = collection["RoomOnlyRate"];
cost.NegotiatedRoomonlyRate = collection["NegotiatedRoomonlyRate"];
cost.BBRate = collection["BBRate"];
cost.BBNegotiatedRate = collection["BBNegotiatedRate"];
cost.DBBRate = collection["DBBRate"];
cost.DBBNegotiatedRate = collection["DBBNegotiatedRate"];
cost.DDRate = collection["DDRate"];
cost.DDNegotiatedRate = collection["DDNegotiatedRate"];
cost.pre24hrRate = collection["pre24hrRate"];
cost.pre24hrNeotiatedRate = collection["pre24hrNeotiatedRate"];
cost.TeaAndCoffee = collection["TeaAndCoffee"];
cost.LastNegotiatedDate = _db.ConvertDate(collection["LastNegotiatedDate"], "dd/MM/yyyy");
cost.Lunch = collection["Lunch"] == "1" ? 1 : 0;
cost.RenegotiateOn = _db.ConvertDate(collection["RenegotiateOn"], "dd/MM/yyyy");
cost.NoOfMeetingRooms = NoOfMeetingRooms;
cost.PreferredStatus = PreferredStatus;
cost.MeetingRoomRatePerDay = collection["MeetingRoomRatePerDay"];
cost.Comments = collection["Comments"];
cost.Codings = Codings;
var model = new PremiseOpenSchedule();
model.StartMonday = collection["StartMonday"];
model.EndMonday = collection["EndMonday"];
model.StartTuesday = collection["StartTuesday"];
model.EndTuesday = collection["EndTuesday"];
model.StartWednesday = collection["StartWednesday"];
model.EndWednesday = collection["EndWednesday"];
model.StartThursday = collection["StartThursday"];
model.EndThursday = collection["EndThursday"];
model.StartFriday = collection["StartFriday"];
model.EndFriday = collection["EndFriday"];
model.StartSaturday = collection["StartSaturday"];
model.EndSaturday = collection["EndSaturday"];
model.StartSunday = collection["StartSunday"];
model.EndSunday = collection["EndSunday"];
var isSaved=_db.CreatePremise(pre, detail, cost, model);
if (isSaved == true)
{
ViewBag.Alert = "true";
ViewBag.Message = "Action success!";
ViewBag.URL = "/Premise/Amend/" + pre.PremiseID;
}
else
{
ViewBag.Alert = "false";
ViewBag.Message = "";
ViewBag.URL = "";
}
return PartialView("../Shared/Redirect");
}
partial void DeletePremiseOpenSchedule(PremiseOpenSchedule instance);
partial void UpdatePremiseOpenSchedule(PremiseOpenSchedule instance);
partial void InsertPremiseOpenSchedule(PremiseOpenSchedule instance);
