public JsonResult GetAllCity(CitySearchFilterVM Obj) { try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); var AllCity = _unitOfWork.NativeSql.GetAllCityInfo(UserInfo.fCompanyId); if (AllCity == null) { return(Json(new List <CitySearchFilterVM>(), JsonRequestBehavior.AllowGet)); } if (Obj.CityID != 0) { AllCity = AllCity.Where(m => m.CityID == Obj.CityID).ToList(); } if (Obj.CountryID != 0) { AllCity = AllCity.Where(m => m.CountryID == Obj.CountryID).ToList(); } return(Json(AllCity, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ViewBag.Error = ex.Message.ToString(); return(Json(new List <CitySearchFilterVM>(), JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateCity(int id) { try { if (id != 0) { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); if (UserInfo == null) { RedirectToAction("", ""); } var AllCountry = _unitOfWork.NativeSql.GetAllCountryInfo(UserInfo.fCompanyId); var CityObj = _unitOfWork.City.GetCityByID(UserInfo.fCompanyId, id); var CountryID = CityObj.CountryID; CitySearchFilterVM Obj = new CitySearchFilterVM { CityID = CityObj.CityID, ArabicName = CityObj.ArabicName, EnglishName = CityObj.EnglishName, Country = AllCountry, CountryID = CityObj.CountryID }; return(View("UpdateCity", Obj)); } return(View("UpdateCity", new CitySearchFilterVM())); } catch (Exception ex) { ViewBag.Error = ex.Message.ToString(); return(View("Error")); } }
public JsonResult SaveCity(CitySearchFilterVM ObjToSave) { MsgUnit Msg = new MsgUnit(); try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); var SaveCity = new City(); ObjToSave.CityID = _unitOfWork.City.GetMaxSerial(UserInfo.fCompanyId); ObjToSave.InsDateTime = DateTime.Now; ObjToSave.InsUserID = userId; ObjToSave.CompanyID = UserInfo.fCompanyId; if (String.IsNullOrEmpty(ObjToSave.EnglishName)) { ObjToSave.EnglishName = ObjToSave.ArabicName; } SaveCity.CityID = ObjToSave.CityID; SaveCity.CountryID = ObjToSave.CountryID; SaveCity.ArabicName = ObjToSave.ArabicName; SaveCity.EnglishName = ObjToSave.EnglishName; SaveCity.InsDateTime = ObjToSave.InsDateTime; SaveCity.InsUserID = ObjToSave.InsUserID; SaveCity.CompanyID = ObjToSave.CompanyID; if (!ModelState.IsValid) { string Err = " "; var errors = ModelState.Values.SelectMany(v => v.Errors); foreach (ModelError error in errors) { Err = Err + error.ErrorMessage + " * "; } Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err; Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } _unitOfWork.City.Add(SaveCity); _unitOfWork.Complete(); Msg.LastID = _unitOfWork.City.GetMaxSerial(UserInfo.fCompanyId).ToString(); Msg.Code = 1; Msg.Msg = Resources.Resource.AddedSuccessfully; return(Json(Msg, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString(); Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveCity() { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); var AllCountry = _unitOfWork.NativeSql.GetAllCountryInfo(UserInfo.fCompanyId); CitySearchFilterVM Obj = new CitySearchFilterVM { CityID = _unitOfWork.City.GetMaxSerial(UserInfo.fCompanyId), Country = AllCountry, CountryID = 1 }; return(View(Obj)); }
public ActionResult Index() { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); var AllCountry = _unitOfWork.NativeSql.GetAllCountryInfo(UserInfo.fCompanyId); var AllCity = _unitOfWork.NativeSql.GetAllCityInfo(UserInfo.fCompanyId); var CityFilter = new CitySearchFilterVM { Country = AllCountry, City = AllCity }; return(View(CityFilter)); }
public JsonResult GetCountryID(int CityID) { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); if (CityID != 0) { var CountryID = _unitOfWork.NativeSql.GetCountryID(UserInfo.fCompanyId, CityID); if (CountryID == null) { CountryID = new CitySearchFilterVM { CountryID = 0 }; } ; return(Json(CountryID.CountryID, JsonRequestBehavior.AllowGet)); } return(Json(0, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteCity(int id) { try { if (id != 0) { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); if (UserInfo == null) { RedirectToAction("", ""); } var CityObj = _unitOfWork.City.GetCityByID(UserInfo.fCompanyId, id); var CountryObj = _unitOfWork.Country.GetCountryByID(UserInfo.fCompanyId, CityObj.CountryID); CitySearchFilterVM Obj = new CitySearchFilterVM { }; Obj.CityID = CityObj.CityID; Obj.ArabicName = CityObj.ArabicName; Obj.EnglishName = CityObj.EnglishName; Obj.CountryID = CityObj.CountryID; if (Resources.Resource.CurLang == "Arb") { Obj.CountryName = CountryObj.ArabicName; } else { Obj.CountryName = CountryObj.EnglishName; } return(View("DeleteCity", Obj)); } return(View("DeleteCity", new CitySearchFilterVM())); } catch (Exception ex) { ViewBag.Error = ex.Message.ToString(); return(View("Error")); } }
public JsonResult DeleteCity(CitySearchFilterVM ObjDelete) { MsgUnit Msg = new MsgUnit(); try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.UserAccount.GetUserByID(userId); var DeleteCity = new City(); ObjDelete.CompanyID = UserInfo.fCompanyId; DeleteCity.CompanyID = ObjDelete.CompanyID; DeleteCity.CityID = ObjDelete.CityID; if (!ModelState.IsValid) { string Err = " "; var errors = ModelState.Values.SelectMany(v => v.Errors); foreach (ModelError error in errors) { Err = Err + error.ErrorMessage + " * "; } Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err; Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } _unitOfWork.City.Delete(DeleteCity); _unitOfWork.Complete(); Msg.Code = 1; Msg.Msg = Resources.Resource.DeletedSuccessfully; return(Json(Msg, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString(); Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } }