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