public bool checkstreet(string streetName) { using (tblStreetsLogic street = new tblStreetsLogic()) { return(street.IsExist(streetName)); } }
//[Authorize] //public JsonResult regPay1(string h) //{ // return Json(JsonRequestBehavior.AllowGet); //} //------------------------------------// // GET: tblStudent public ActionResult Index() { using (var logic = new tblStudentLogic()) { ViewBag.Classes = logic.Classes(); ViewBag.Shicvas = logic.Shicvas(); ViewBag.DefaultCityId = logic.DefaultCityId; } if (ViewBag.DefaultCityId > 0) { using (var logic5 = new tblStreetsLogic()) { ViewBag.DefaultCity = logic5.GetCityById(ViewBag.DefaultCityId); } } using (var logic2 = new LineLogic()) { ViewBag.Lines = logic2.GetList(); } using (var logic3 = new StationsLogic()) { ViewBag.Stations = logic3.GetList(); } using (var logic4 = new tblFamilyLogic()) { ViewBag.Families = JsonConvert.SerializeObject(logic4.GetAll().Select(z => new { Id = z.familyId, Name = z.parent1FirstName + " " + z.parent1LastName + (z.oneParentOnly ? "" : " / " + z.parent2FirstName + " " + z.parent2LastName) })); } using (var logic5 = new tblSchoolLogic()) { ViewBag.Schools = JsonConvert.SerializeObject(logic5.GetList().Select(z => new { Id = z.id, Name = z.name })); } return(View()); }
public string getStreetList(string id) { if (!string.IsNullOrEmpty(id) && id.Length > 2) { List <tblStreet> selected = null; if (HttpRuntime.Cache["streets"] == null) { using (tblStreetsLogic streets = new tblStreetsLogic()) { List <tblStreet> c = streets.GetStreets(); HttpRuntime.Cache.Insert("streets", c, null, Cache.NoAbsoluteExpiration, TimeSpan.FromHours(5), CacheItemPriority.High, null); selected = c.Where(O => O.streetName.Contains(id.Trim())).ToList(); } } else { List <tblStreet> c = HttpRuntime.Cache["streets"] as List <tblStreet>; selected = c.Where(O => O.streetName.Contains(id.Trim())).ToList(); } var jsonSerialiser = new JavaScriptSerializer(); var list = jsonSerialiser.Serialize(selected); return(list); //OLD VER BY DB //using (tblStreetsLogic streets = new tblStreetsLogic()) //{ // List<tblStreet> c = streets.GetStreetsByprefix(id); // var jsonSerialiser = new JavaScriptSerializer(); // var list = jsonSerialiser.Serialize(c); // return list; //} } return(null); }