public ActionResult Modify(etblPropertyRecreationMap obj) { try { if (ModelState.IsValid) { try { obj.dtActionDate = DateTime.Now; //get all On Site Recreation Facilities comma seperated if (obj.SelectedOnSiteRecreationfacilities != null) { obj.sRecreationFacilityId = obj.SelectedOnSiteRecreationfacilities.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all Land Activities comma seperated if (obj.SelectedLandActivities != null) { obj.sLandActivityId = obj.SelectedLandActivities.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all golf comma seperated if (obj.SelectedGolf != null) { obj.sGolfId = obj.SelectedGolf.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all Meetings comma seperated obj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; int result = BL_tblPropertyRecreationMap.UpdateRecord(obj); if (result == 1) { TempData["msg"] = "Fitness and Recreation Modified Successfully"; return(RedirectToAction("Index")); } else { TempData["ERROR"] = "Kindly try after some time."; return(RedirectToAction("Index")); } obj.OnSiteRecreationfacilitiesItems = BL_tblOnsiteRecreationFacilitiesM.GetOnsiteRecreationFacilities(obj.sRecreationFacilityId); obj.LandActivitiesItems = BL_tblLandActivitiesM.GetLandActivities(obj.sLandActivityId); obj.GolfItems = BL_tblGolfM.GetGolf(obj.sGolfId); } catch (Exception) { TempData["ERROR"] = "Kindly try after some time."; throw; } } } catch (Exception) { TempData["ERROR"] = "Kindly try after some time."; } return(View("~/Views/FitnessRecreation/Index.cshtml", obj)); }
// GET: FitnessRecreation //[OutputCache(NoStore = true, Duration = 0, VaryByParam = "*")] public ActionResult Index() { etblPropertyRecreationMap obj = new etblPropertyRecreationMap(); obj = BL_tblPropertyRecreationMap.GetSingleRecordById(Convert.ToInt32(Session["PropId"])); obj.iPropId = Convert.ToInt32(Session["PropId"]); obj.OnSiteRecreationfacilitiesItems = BL_tblOnsiteRecreationFacilitiesM.GetOnsiteRecreationFacilities(obj.sRecreationFacilityId); obj.LandActivitiesItems = BL_tblLandActivitiesM.GetLandActivities(obj.sLandActivityId); obj.GolfItems = BL_tblGolfM.GetGolf(obj.sGolfId); return(View(obj)); }
//Get Single Record public static etblPropertyRecreationMap GetSingleRecordById(int id) { etblPropertyRecreationMap eobj = new etblPropertyRecreationMap(); using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = db.tblPropertyRecreationMaps.SingleOrDefault(u => u.iPropId == id); if (dbobj != null) { eobj = (etblPropertyRecreationMap)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj); } } return(eobj); }
//Update a record public static int UpdateRecord(etblPropertyRecreationMap eobj) { bool Type = false; int retval = 0; using (OneFineRateEntities dbnew = new OneFineRateEntities()) { try { var dbobj = dbnew.tblPropertyRecreationMaps.SingleOrDefault(u => u.iPropId == eobj.iPropId); if (dbobj != null) { Type = true; } } catch (Exception) { throw; } } using (OneFineRateEntities db = new OneFineRateEntities()) { try { if (Type) { OneFineRate.tblPropertyRecreationMap obj = (OneFineRate.tblPropertyRecreationMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRecreationMap()); db.tblPropertyRecreationMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } else { OneFineRate.tblPropertyRecreationMap dbuser = (OneFineRate.tblPropertyRecreationMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRecreationMap()); db.tblPropertyRecreationMaps.Add(dbuser); db.SaveChanges(); retval = 1; } } catch (Exception) { throw; } } return(retval); }