public ActionResult GetStates(JqGridSettings gridSettings) { var states = DatabaseDAL.GetAllStates(); var stateList = new List <State>(); foreach (var state in states) { stateList.Add(state); } int totalPages; int totalRecords; var allStates = stateList.AsQueryable(); var results = jqGridDataManager.GetGridData <State>(gridSettings, allStates, out totalPages, out totalRecords); JqGridResult result = new JqGridResult() { Page = gridSettings.PageIndex, Records = totalRecords, Total = totalPages, Rows = results.ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetCustomers(JqGridSettings gridSettings) { int totalPages; int totalRecords; var allProducts = DatabaseDAL.GetAllProductModels(); var results = jqGridDataManager.GetGridData <ProductModel>(gridSettings, allProducts, out totalPages, out totalRecords); JqGridResult result = new JqGridResult() { Page = gridSettings.PageIndex, Records = totalRecords, Total = totalPages, Rows = results.ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }
private void SearchEquipment(HttpContext context, Dictionary <string, object> jsData) { JqGridDataObject <ReportMitkanim> dataObject = BuildEquipmentColModel(); int mahozId, mitkanNum, rashutId; if (jsData["mahoz"] == null || !int.TryParse(jsData["mahoz"].ToString(), out mahozId)) { mahozId = -1; } if (jsData["area"] == null || !int.TryParse(jsData["area"].ToString(), out rashutId)) { rashutId = -1; } if (jsData["equip"] == null || !int.TryParse(jsData["equip"].ToString(), out mitkanNum)) { mitkanNum = -1; } SearchMitkanimResponse response = ManageSearch.SearchEquipment(mahozId, mitkanNum, rashutId); if (response != null && !response.IsError) { dataObject.datastr = response.Data.ToList(); } JqGridResult <ReportMitkanim> result = new JqGridResult <ReportMitkanim>() { jqGridDataObject = dataObject }; if (response.IsError) { result.errorMessage = response.ErrorDesc; } JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(result); context.Response.Write(json); }
private void SearchEvacuees(HttpContext context, Dictionary <string, object> jsData) { JqGridDataObject <ShiltonMekomi> dataObject = BuildEvacueesColModel(); #region Fill Values in Vars int? AreaId = null, CityId = null, streetId = null, EqMahozId = null, equipId = null; DateTime?DateIncomeBegin = null, DateIncomeEnd = null; long? IdNumber = null; if (jsData["AreaId"] != null && !string.IsNullOrEmpty(jsData["AreaId"].ToString())) { AreaId = int.Parse(jsData["AreaId"].ToString()); } if (jsData["EqMahozId"] != null && !string.IsNullOrEmpty(jsData["EqMahozId"].ToString())) { EqMahozId = int.Parse(jsData["EqMahozId"].ToString()); } if (jsData["equipId"] != null && !string.IsNullOrEmpty(jsData["equipId"].ToString())) { equipId = int.Parse(jsData["equipId"].ToString()); } if (jsData["City"] != null && !string.IsNullOrEmpty(jsData["City"].ToString())) { CityId = GetCitiesCache(context) .Where(c => c.YeshuvName == jsData["City"].ToString()) .Select(c => c.YeshuvNum) .FirstOrDefault(); } if (jsData["street"] != null && !string.IsNullOrEmpty(jsData["street"].ToString())) { streetId = GetStreetsCache(context) .Where(s => s.StName == jsData["street"].ToString()) .Select(s => s.StNum) .FirstOrDefault(); } if (jsData["DateIncomeBegin"] != null && !string.IsNullOrEmpty(jsData["DateIncomeBegin"].ToString())) { string[] formats = { "MM/dd/yyyy" }; DateIncomeBegin = DateTime.ParseExact(jsData["DateIncomeBegin"].ToString(), formats, new CultureInfo("he-IL"), DateTimeStyles.None); } if (jsData["DateIncomeEnd"] != null && !string.IsNullOrEmpty(jsData["DateIncomeEnd"].ToString())) { string[] formats = { "MM/dd/yyyy" }; DateIncomeEnd = DateTime.ParseExact(jsData["DateIncomeEnd"].ToString(), formats, new CultureInfo("he-IL"), DateTimeStyles.None); } if (jsData["IdNumber"] != null && !string.IsNullOrEmpty(jsData["IdNumber"].ToString())) { IdNumber = long.Parse(jsData["IdNumber"].ToString()); } #endregion SearchResponse response = ManageSearch.SearchEvacuees(jsData["firstName"] != null? jsData["firstName"].ToString() : null, jsData["lastName"] != null ? jsData["lastName"].ToString() : null, jsData["fatherName"] != null ? jsData["fatherName"].ToString() : null, jsData["gender"] != null ? jsData["gender"].ToString() : null, IdNumber, DateIncomeBegin, DateIncomeEnd, AreaId, CityId, streetId, EqMahozId, equipId); if (!response.IsError) { dataObject.datastr = response.ShiltonMekomi.ToList(); } JqGridResult <ShiltonMekomi> result = new JqGridResult <ShiltonMekomi>() { jqGridDataObject = dataObject, groupHeaders = new GroupHeaders() { groupHeaders = new List <GroupHeader>() { //new GroupHeader(){startColumnName = "LastName", numberOfColumns = 10, titleText = "פרטי מפונה"}, new GroupHeader() { startColumnName = "LocalArea", numberOfColumns = 4, titleText = "כתובת מגורים" }, new GroupHeader() { startColumnName = "EqLocalArea", numberOfColumns = 4, titleText = "פרטי מרכז קליטה" } } } }; if (response.IsError) { result.errorMessage = response.ErrorDesc; } JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(result); context.Response.Write(json); }