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