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