public JsonResult GetRangeGata([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
PositionRCollection collection = T_COM_Master_PositionManager.GetPositionRange(SystemConfig.DefaultEntity);
int TotalRecord = 0;
if (collection.Count > 0)
{
TotalRecord = collection[0].TotalRecord;
}
return(Json(new DataTablesResponse(requestModel.Draw, collection, TotalRecord, TotalRecord), JsonRequestBehavior.AllowGet));
}
public static PositionRCollection GetPostionRangesalary(int EntityID)
{
PositionRCollection collection = new PositionRCollection();
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@EntityID", EntityID);
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Position_Range", sqlParams))
{
while (reader.Read())
{
PositionR obj = new PositionR();
obj = GetPositionRFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public string ExportExcelRange()
{
PositionRCollection collection = T_COM_Master_PositionManager.GetPositionRange(SystemConfig.DefaultEntity);
DataTable dt = collection.ToDataTable <PositionR>();
string fileName = "T_COM_Master_Position_" + 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, "T_COM_Master_Position List", false);
return(fileName);
}
public static PositionRCollection GetPositionRange(int EntityID)
{
PositionRCollection items = new PositionRCollection();
string key = SETTINGS_ALL_KEY;
//object obj2 = HttpCache.Get(key);
//if ((obj2 != null))
//{
// return (PositionRCollection)obj2;
//}
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.GetAsync(string.Format(Resource + "?EntityID={0}&Mode=0", EntityID)).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
items = response.Content.ReadAsAsync <PositionRCollection>().GetAwaiter().GetResult();
}
}
HttpCache.Max(key, items);
return(items);
}
