public string DeleteLocality(int id, string status) { object result = null; string strReturn = string.Empty; try { etblLocality obj = new etblLocality(); obj = BL_Locality.GetSingleRecordById(id); obj.cStatus = status; obj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; int i = BL_Locality.UpdateRecord(obj); if (i == 1) { result = new { st = 1, msg = clsUtils.ErrorMsg("Locality", 4, status) }; } else { result = new { st = 0, msg = clsUtils.ErrorMsg("Locality", 0) }; } } catch (Exception) { result = new { st = 0, msg = clsUtils.ErrorMsg("", 3) }; } strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); }
public JsonResult BindLocality(string id) { int cid = int.Parse(id); List <etblLocality> results = BL_Locality.LocalityList(cid); return(Json(new { suggestions = results }, JsonRequestBehavior.AllowGet)); }
public JsonResult Autocomplete(string term) { var result = new List <KeyValuePair <string, string> >(); IList <PNames> List = new List <PNames>(BL_Locality.GetAllLocality(Convert.ToInt32(Session["PropId"]), term)); foreach (var item in List) { result.Add(new KeyValuePair <string, string>(item.Id.ToString(), item.Name)); } var result3 = result.Where(s => s.Value.ToLower().Contains(term.ToLower())).Select(w => w).ToList(); return(Json(result3, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { etblPropertyM obj = new etblPropertyM(); obj.StateList = BL_tblStateM.StateList(obj.iStateId, obj.iCountryId); obj.CityList = BL_tblCityM.CityList(obj.iCityId, obj.iStateId, obj.iCountryId); obj.AreaList = BL_tblMacroAreaM.AreasList(obj.iAreaId, obj.iCityId); obj.LocalityList = BL_Locality.LocalityList(obj.iLocalityId, obj.iAreaId); obj.Mode = "Add"; obj.latitude = Convert.ToDecimal("28.577286048"); obj.longitude = Convert.ToDecimal("77.203674316"); obj.sInitialHotelName = ""; return(View(obj)); }
// GET: SearchHotel public ActionResult Index(PropDetailsForBooking prop) { // int LocalityId = 8; // DateTime dtCheckIn = Convert.ToDateTime("2016-06-20"); // DateTime dtCheckOut = Convert.ToDateTime("2016-06-21"); // List<PropDetailsForHotelBooking> data = BL_Locality.GetAllProperty(LocalityId, dtCheckIn, dtCheckOut); // PropDetailsForBooking obj = new PropDetailsForBooking(); // if (data.Count > 0) // { // foreach (var item in data) // { // obj.PropDetailsList.Add(item); // } // } //return View(obj); int LocalityId = 2; DateTime dtCheckIn = Convert.ToDateTime("2016-06-20"); DateTime dtCheckOut = Convert.ToDateTime("2016-06-21"); if (prop.PropDetailsList.Count != 0) { LocalityId = prop.iLocalityId; dtCheckIn = prop.PropDetailsList[0].dtCheckIn == null ? DateTime.Now : Convert.ToDateTime(prop.PropDetailsList[0].dtCheckIn); dtCheckOut = prop.PropDetailsList[0].dtCheckOut == null ? DateTime.Now : Convert.ToDateTime(prop.PropDetailsList[0].dtCheckOut); } List <PropDetailsForHotelBooking> data = BL_Locality.GetAllProperty(LocalityId, dtCheckIn, dtCheckOut); PropDetailsForBooking obj = new PropDetailsForBooking(); if (data.Count > 0) { foreach (var item in data) { obj.PropDetailsList.Add(item); } } else { obj = prop; } return(View("Index", obj)); }
public ActionResult Edit() { int id = 0; if (Session["PropId"] != null) { id = Convert.ToInt32(Session["PropId"].ToString()); } else { throw new Exception("Property ID Null"); } etblPropertyM_User obj = new etblPropertyM_User(); try { obj = BL_tblPropertyM.GetSingleRecordById_User(id); obj.sviewType = "Edit"; obj.StateList = BL_tblStateM.StateList(obj.iStateId, obj.iCountryId); obj.CityList = BL_tblCityM.CityList(obj.iCityId, obj.iStateId, obj.iCountryId); obj.AreaList = BL_tblMacroAreaM.AreasList(obj.iAreaId, obj.iCityId); obj.LocalityList = BL_Locality.LocalityList(obj.iLocalityId, obj.iAreaId); obj.AccessbilityItems = BL_tblAccessbilityM.GetAccessbilities(obj.sAccessbilityIds); obj.AwardsItems = BL_tblAwardM.GetAwards(obj.sAwardIds); obj.AffilationItems = BL_tblAffiliationM.GetAffilations(obj.sAffiliationIds); obj.LanguagesItems = BL_tblLanguageM.GetLanguages(obj.sLanguageIds); //for only showing purpose obj.sHotelNameO = obj.sHotelName; obj.iChainIdO = obj.iChainId; obj.iCountryIdO = obj.iCountryId; obj.iStateIdO = obj.iStateId; obj.iCityIdO = obj.iCityId; obj.iAreaIdO = obj.iAreaId; obj.iLocalityIdO = obj.iLocalityId; ViewBag.PropertyLocalityMap = GetLocalitiesJson(BL_tblPropertyM.GetPropertyLocalityMap(id)); } catch (Exception) { throw; } return(View(obj)); }
public ActionResult Modify(PropDetailsForBooking prop) { int LocalityId = prop.iLocalityId; DateTime dtCheckIn = prop.PropDetailsList[0].dtCheckIn == null ? DateTime.Now : Convert.ToDateTime(prop.PropDetailsList[0].dtCheckIn); DateTime dtCheckOut = prop.PropDetailsList[0].dtCheckOut == null ? DateTime.Now : Convert.ToDateTime(prop.PropDetailsList[0].dtCheckOut); List <PropDetailsForHotelBooking> data = BL_Locality.GetAllProperty(LocalityId, dtCheckIn, dtCheckOut); PropDetailsForBooking obj = new PropDetailsForBooking(); if (data.Count > 0) { foreach (var item in data) { obj.PropDetailsList.Add(item); } } else { obj = prop; } return(View("Index", obj)); }
public ActionResult EditMaster(int id) { etblPropertyM obj = new etblPropertyM(); try { obj = BL_tblPropertyM.GetSingleRecordById(id); obj.sviewType = "EditMaster"; obj.StateList = BL_tblStateM.StateList(obj.iStateId, obj.iCountryId); obj.CityList = BL_tblCityM.CityList(obj.iCityId, obj.iStateId, obj.iCountryId); obj.AreaList = BL_tblMacroAreaM.AreasList(obj.iAreaId, obj.iCityId); obj.LocalityList = BL_Locality.LocalityList(obj.iLocalityId, obj.iAreaId); obj.latitude = obj.dLatitude; obj.longitude = obj.dLongitude; obj.Mode = "Edit"; obj.sInitialHotelName = obj.sHotelName; } catch (Exception ex) { throw; } return(View("Index", obj)); }
public string AddLocality(int countryid, int stateid, int cityid, int areaid, string localityname) { object result = null; string strReturn = string.Empty; try { etblLocality eObj = new etblLocality(); eObj.iCountryId = countryid; eObj.iStateId = stateid; eObj.iCityId = cityid; eObj.iAreaId = areaid; eObj.sLocality = localityname; eObj.dtActionDate = DateTime.Now; eObj.cStatus = "A"; eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; int i = BL_Locality.AddRecord(eObj); if (i == 1) { result = new { st = 1, msg = clsUtils.ErrorMsg("Locality", 1) }; } else if (i == 2) { result = new { st = 0, msg = clsUtils.ErrorMsg("Locality", 0) }; } else { result = new { st = 0, msg = clsUtils.ErrorMsg("Locality", 3) }; } } catch (Exception ex) { result = new { st = 0, msg = clsUtils.ErrorMsg("", 3) }; } strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); }
public string UpdateLocality(int id, int countryid, int stateid, int cityid, int areaid, string localityname) { object result = null; string strReturn = string.Empty; try { etblLocality obj = new etblLocality(); obj = BL_Locality.GetSingleRecordById(id); obj.iCountryId = countryid; obj.iStateId = stateid; obj.iCityId = cityid; obj.iAreaId = areaid; obj.sLocality = localityname; obj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; int i = BL_Locality.UpdateRecord(obj); if (i == 1) { result = new { st = 1, msg = clsUtils.ErrorMsg("Locality", 2) }; } else if (i == 2) { result = new { st = 0, msg = clsUtils.ErrorMsg("Locality", 0) }; } else { result = new { st = 0, msg = clsUtils.ErrorMsg("Locality", 1) }; } } catch (Exception) { result = new { st = 0, msg = clsUtils.ErrorMsg("", 3) }; } strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result); return(strReturn); }
public ActionResult Modify(etblPropertyM_User prop) { try { if (ModelState.IsValid) { try { prop.dtActionDate = DateTime.Now; //get all AccessbilityId comma seperated if (prop.SelectedAccessbility != null) { prop.sAccessbilityIds = prop.SelectedAccessbility.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all AwardsIds comma seperated if (prop.SelectedAwards != null) { prop.sAwardIds = prop.SelectedAwards.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all AffilationsIds comma seperated if (prop.SelectedAffilations != null) { prop.sAffiliationIds = prop.SelectedAffilations.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all languages comma seperated if (prop.SelectedLanguages != null) { prop.sLanguageIds = prop.SelectedLanguages.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } if (prop.SelectPrimaryLocalities != null) { JArray jArray = (JArray)JsonConvert.DeserializeObject(prop.SelectPrimaryLocalities.Replace("\\", "\"")); if (jArray != null) { List <etblPropertyLocalityMap> lstPropertyLocalityMap = new List <etblPropertyLocalityMap>(); foreach (var item in jArray) { lstPropertyLocalityMap.Add(new etblPropertyLocalityMap() { iPropId = prop.iPropId, iAreaLocalityId = Convert.ToInt32(item["Id"]), cAreaLocality = Convert.ToString(item["Status"]), dtActionDate = DateTime.Now, iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId }); } prop.PropertyLocalityMapList = lstPropertyLocalityMap; } } prop.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; int result = BL_tblPropertyM.UpdateRecord_User(prop); if (result == 1) { TempData["msg"] = "Property Informaion Modified Successfully"; return(RedirectToAction("Edit")); } else { TempData["Error"] = "Some unknown error had happen !"; return(View(prop.sviewType, prop)); } } catch (Exception) { throw; } } prop.AccessbilityItems = BL_tblAccessbilityM.GetAccessbilities(prop.sAccessbilityIds); prop.AwardsItems = BL_tblAwardM.GetAwards(prop.sAwardIds); prop.AffilationItems = BL_tblAffiliationM.GetAffilations(prop.sAffiliationIds); prop.LanguagesItems = BL_tblLanguageM.GetLanguages(prop.sLanguageIds); prop.StateList = BL_tblStateM.StateList(prop.iStateId, prop.iCountryId); prop.CityList = BL_tblCityM.CityList(prop.iCityId, prop.iStateId, prop.iCountryId); prop.AreaList = BL_tblMacroAreaM.AreasList(prop.iAreaId, prop.iCityId); prop.LocalityList = BL_Locality.LocalityList(prop.iLocalityId, prop.iAreaId); //prop.sAccessbilityIds = prop.SelectedAccessbility.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); ////get all AwardsIds comma seperated //prop.sAwardIds = prop.SelectedAwards.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); ////get all AffilationsIds comma seperated //prop.sAffiliationIds = prop.SelectedAffilations.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); ////get all languages comma seperated //prop.sLanguageIds = prop.SelectedLanguages.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); //for only showing purpose prop.sHotelNameO = prop.sHotelName; prop.iChainIdO = prop.iChainId; prop.iCountryIdO = prop.iCountryId; prop.iStateIdO = prop.iStateId; prop.iCityIdO = prop.iCityId; prop.iAreaIdO = prop.iAreaId; prop.iLocalityIdO = prop.iLocalityId; ViewBag.PropertyLocalityMap = GetLocalitiesJson(BL_tblPropertyM.GetPropertyLocalityMap(prop.iPropId)); TempData["Error"] = "Validation failed ! Please correct the errors and try again."; } catch (Exception) { } return(View(prop.sviewType, prop)); }
public ActionResult Add(etblPropertyM prop) { if (ModelState.IsValid) { try { prop.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId; prop.dtActionDate = DateTime.Now; if (prop.Mode == "Add") { prop.cStatus = "I"; int result = BL_tblPropertyM.AddRecord(prop); if (result == 1) { TempData["msg"] = "Property Added Successfully"; return(RedirectToAction("List")); } else { return(View("Index", prop)); } } else { int result = BL_tblPropertyM.UpdateRecord(prop); if (result == 1) { TempData["msg"] = "Property Modified Successfully"; return(RedirectToAction("List")); } else { return(View("Index", prop)); } } } catch (Exception) { throw; } } else { TempData["ERROR"] = "Validation failed! Please correct the errors and try again."; prop.StateList = BL_tblStateM.StateList(prop.iStateId, prop.iCountryId); prop.CityList = BL_tblCityM.CityList(prop.iCityId, prop.iStateId, prop.iCountryId); prop.AreaList = BL_tblMacroAreaM.AreasList(prop.iAreaId, prop.iCityId); prop.LocalityList = BL_Locality.LocalityList(prop.iLocalityId, prop.iAreaId); prop.latitude = prop.dLatitude; prop.longitude = prop.dLongitude; prop.Mode = "Edit"; return(View("Index", prop)); } //else //{ // string errormsg = ""; // foreach (ModelState modelState in ViewData.ModelState.Values) // { // foreach (ModelError error in modelState.Errors) // { // errormsg += error.ErrorMessage; // errormsg += "</br>"; // } // } //} }
public JsonResult GetLocations(string txt, int cityId) { List <PNames> data = BL_Locality.MacroLocalitiesAjaxCall(txt, cityId); return(Json(data, JsonRequestBehavior.AllowGet)); }