public ActionResult LocationDetailGet(LocationDetailModel model) { string html = null; try { DataTable dt = obj.FunDataTable("SELECT * from dbo.CityDetail_Get ()"); if (dt.Rows.Count > 0) { int[] columnHide = { 0 }; StringBuilder htmlTable = CommonUtil.htmlTableEditMode(dt, columnHide); return(Json(new { Flag = 0, Html = htmlTable.ToString() }, JsonRequestBehavior.AllowGet)); } else { html = "<div class='alert alert-danger'>'" + Resources.Resource1.norecord + "'</div>"; return(Json(new { Flag = 0, Html = html }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { html = "Fatch Result Failed !!!"; return(Json(new { Flag = 2, Html = html }, JsonRequestBehavior.AllowGet)); } }
public ActionResult LocationDetailDelete(LocationDetailModel model) { string html = null; try { int a = obj.FunExecuteNonQuery("exec dbo.CityDetail_Delete '" + model.CityId + "'"); if (a > 0) { //return RedirectToAction("PropertyTypeGet"); DataTable dt = obj.FunDataTable("SELECT * from dbo.CityDetail_Get ()"); if (dt.Rows.Count > 0) { int[] columnHide = { 0 }; StringBuilder htmlTable = CommonUtil.htmlTableEditMode(dt, columnHide); return(Json(new { Flag = 0, Html = htmlTable.ToString() }, JsonRequestBehavior.AllowGet)); } else { html = "<div class='alert alert-danger'>'" + Resources.Resource1.norecord + "'</div>"; return(Json(new { Flag = 0, Html = html }, JsonRequestBehavior.AllowGet)); } } else { html = Resources.Resource1.deletefailed; return(Json(new { Flag = 2, Html = html }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { html = Resources.Resource1.deletefailed; return(Json(new { Flag = 2, Html = html }, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateLocation(LocationDetailModel oLocationInfo, string chkIsActive) { try { if (ModelState.IsValid) { oCurrentUser = (SysUser)Session["User"]; var existLocation = oDBContext.OfferLocations.FirstOrDefault(t => t.ID == oLocationInfo.Location.ID); if (existLocation != null) { existLocation.LocationName = oLocationInfo.Location.LocationName; existLocation.ModifiedBy = oCurrentUser.ID; existLocation.ModifiedOn = DateTime.Now; existLocation.IsActive = (!string.IsNullOrEmpty(chkIsActive) && chkIsActive.Contains("on")) ? true : false; oDBContext.SaveChanges(); TempData["SuccessMsg"] = "Data Update Successfully"; } else { TempData["ErrorMsg"] = "Data Not Found!!!"; } } } catch (Exception ex) { TempData["ErrorMsg"] = "Error Occured Due to " + ExceptionMsg(ex); } return(RedirectToAction("Index")); }
public ActionResult InsertLocation(LocationDetailModel oLocationInfo) { try { if (ModelState.IsValid) { oCurrentUser = (SysUser)Session["User"]; var existLocation = oDBContext.OfferLocations.FirstOrDefault(t => t.ID == oLocationInfo.Location.ID); if (existLocation == null) { OfferLocation oOfferLocation = oLocationInfo.Location; oOfferLocation.IsActive = true; oOfferLocation.CreatedBy = oCurrentUser.ID; oOfferLocation.CreatedOn = DateTime.Now; oDBContext.OfferLocations.Add(oOfferLocation); oDBContext.SaveChanges(); TempData["SuccessMsg"] = "Data Saved Successfully"; } else { TempData["ErrorMsg"] = "Data already Exists!!!"; } } } catch (Exception ex) { TempData["ErrorMsg"] = "Error Occured Due to " + ExceptionMsg(ex); } return(RedirectToAction("Index")); }
public ActionResult UpdateLocation(int id) { var LocationInfo = new LocationDetailModel(); LocationInfo.IsNew = false; LocationInfo.Location = oDBContext.OfferLocations.FirstOrDefault(t => t.ID == id); ViewBag.LocationList = oDBContext.OfferLocations.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.LocationName.ToString() }); return(PartialView("_locationDetailPartial", LocationInfo)); }
public ActionResult NewLocation() { oCurrentUser = (SysUser)Session["User"]; var newLocation = new OfferLocation(); newLocation.IsActive = false; var LocationInfo = new LocationDetailModel(); LocationInfo.IsNew = true; LocationInfo.Location = newLocation; ViewBag.LocationList = oDBContext.OfferLocations.Select(x => x).ToList().Select(x => new SelectListItem { Value = x.ID.ToString(), Text = x.LocationName.ToString() }); return(PartialView("_locationDetailPartial", LocationInfo)); }