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;
            }
        }
        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");
        }
		private void detach_Premises(Premise entity)
		{
			this.SendPropertyChanging();
			entity.Contact = null;
		}
		private void attach_Premises(Premise entity)
		{
			this.SendPropertyChanging();
			entity.Contact = this;
		}
 partial void DeletePremise(Premise instance);
 partial void UpdatePremise(Premise instance);
 partial void InsertPremise(Premise instance);
		private void detach_Premises(Premise entity)
		{
			this.SendPropertyChanging();
			entity.Organisation = null;
		}