public JsonResult GetGata([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
ColumnCollection col = requestModel.Columns;
string OrderBy = "PositionID", OrderDirection = "ASC";
foreach (Column item in col)
{
//if (item.IsOrdered && item.Data!="EmpPoint")
if (item.IsOrdered)
{
OrderBy = item.Data;
OrderDirection = item.SortDirection == Column.OrderDirection.Ascendant ? "ASC" : "DESC";
break;
}
}
SearchFilter SearchKey = new SearchFilter()
{
CompanyID = CurrentUser.CompanyID,
Keyword = requestModel.Search.Value,
Page = (requestModel.Start / requestModel.Length) + 1,
PageSize = requestModel.Length,
ColumnsName = "PositionID,Description",
OrderBy = OrderBy,
OrderDirection = OrderDirection,
};
EPPositionCollection collection = EPPositionManager.Search(SearchKey);
int TotalRecord = 0;
if (collection.Count > 0)
{
TotalRecord = collection[0].TotalRecord;
}
//EPPositionCollection data = EPPositionManager.GetAll(CurrentUser.CompanyID);
return(Json(new DataTablesResponse(requestModel.Draw, collection, TotalRecord, TotalRecord), JsonRequestBehavior.AllowGet));
}
public ContentResult Search(SearchFilter SearchKey)
{
SearchKey.OrderBy = string.IsNullOrEmpty(SearchKey.OrderBy) ? "PositionID" : SearchKey.OrderBy;
EPPositionCollection collection = EPPositionManager.Search(SearchKey);
return(Content(JsonConvert.SerializeObject(collection), "application/json"));
}
public static EPPositionCollection Search(SearchFilter value)
{
EPPositionCollection items = new EPPositionCollection();
string key = string.Format(SETTINGS_Search_KEY, value.CompanyID + value.Keyword + value.Page + value.PageSize + value.OrderBy + value.OrderDirection);
if (SystemConfig.AllowSearchCache)
{
object obj2 = HttpCache.Get(key);
if ((obj2 != null))
{
return((EPPositionCollection)obj2);
}
}
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.PostAsJsonAsync(Resource + "?method=search", value).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
items = response.Content.ReadAsAsync <EPPositionCollection>().GetAwaiter().GetResult();
}
}
if (SystemConfig.AllowSearchCache)
{
HttpCache.Max(key, items);
}
return(items);
}
/// <summary>
/// ExportExcel File
/// </summary>
/// <returns></returns>
public string ExportExcel()
{
EPPositionCollection collection = EPPositionManager.GetAll(CurrentUser.CompanyID);
DataTable dt = collection.ToDataTable <EPPosition>();
string fileName = "EPPosition_" + SystemConfig.CurrentDate.ToString("MM-dd-yyyy");
string[] RemoveColumn = { "CompanyID", "TargetDisplayID", "ReturnDisplay", "TotalRecord", "CreatedUser", "CreatedDate" };
for (int i = 0; i < RemoveColumn.Length; i++)
{
if (dt.Columns.Contains(RemoveColumn[i]))
{
dt.Columns.Remove(RemoveColumn[i]);
}
}
FileInputHelper.ExportExcel(dt, fileName, "EPPosition List", false);
return(fileName);
}
public static EPPositionCollection GetAll(int CompanyID)
{
EPPositionCollection items = new EPPositionCollection();
string key = String.Format(SETTINGS_ALL_KEY, CompanyID);
object obj2 = HttpCache.Get(key);
if ((obj2 != null))
{
return((EPPositionCollection)obj2);
}
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.GetAsync(string.Format(Resource + "?CompanyID={0}", CompanyID)).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
items = response.Content.ReadAsAsync <EPPositionCollection>().GetAwaiter().GetResult();
}
}
HttpCache.Max(key, items);
return(items);
}
public ActionResult list()
{
EPPositionCollection collection = EPPositionManager.GetAll(1);
return(View(ViewFolder + "list.cshtml", collection));
}
