public ActionResult DataArtista(Syncfusion.JavaScript.DataManager dm)
{
DataResultArtista result = new DataResultArtista();
Syncfusion.JavaScript.DataSources.DataOperations dataOperations = new Syncfusion.JavaScript.DataSources.DataOperations();
result.result = context.Artistas.ToList();
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
result.result = dataOperations.PerformSorting(result.result, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
result.result = dataOperations.PerformWhereFilter(result.result, dm.Where, dm.Where[0].Operator);
if (!dm.RequiresCounts)
{
return(Json(result.result));
}
}
result.count = context.Artistas.AsQueryable().Count();
if (dm.Skip != 0)
{
result.result = dataOperations.PerformSkip(result.result, dm.Skip);
}
if (dm.Take != 0)
{
result.result = dataOperations.PerformTake(result.result, dm.Take);
}
return(Json(new { result = result.result, count = result.count }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetOrder_Lab(Syncfusion.JavaScript.DataManager dm, int FC, string StartDate, string EndDate)
{
DateTime?sDate = DateTime.ParseExact(StartDate, "dd/MM/yyyy", null);
DateTime?eDate = DateTime.ParseExact(EndDate, "dd/MM/yyyy", null);
LaboratoryModels obj = new LaboratoryModels();
//IEnumerable DataSource = obj.getOrders(18, DateTime.Parse("2017-04-01 00:00:00.000"), DateTime.Parse("2017-05-31 00:00:00.000"));
context.Configuration.ProxyCreationEnabled = false;
IEnumerable data = obj.GetOrder_Add(FC, sDate, eDate).ToList();
int count = obj.GetOrder_Add(FC, sDate, eDate).Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
//GetOrder_Add
public ActionResult GetOrderCustom(Syncfusion.JavaScript.DataManager dm, string param_on)
{
//string a = start_date.ToString();
//string b = end_date.ToString();
TBModels obj = new TBModels();
//IEnumerable DataSource = obj.getOrders(18, DateTime.Parse("2017-04-01 00:00:00.000"), DateTime.Parse("2017-05-31 00:00:00.000"));
context.Configuration.ProxyCreationEnabled = false;
IEnumerable data = obj.GetOrderCustom(param_on);
int count = obj.GetOrderCustom(param_on).Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public ActionResult BatchDataSMC(Syncfusion.JavaScript.DataManager dm, int?Code)
{
IEnumerable Data = context.Order_SMC_SLM_Physical_Count.Where(a => a.ProductCode == Code).ToList();
DataResult result = new DataResult();
DataOperations operation = new DataOperations();
result.count = context.Order_SMC_SLM_Physical_Count.Where(a => a.ProductCode == Code).ToList().Count();
if (dm.Skip > 0)
{
Data = operation.PerformSkip(Data, dm.Skip);
}
if (dm.Take > 0)
{
Data = operation.PerformTake(Data, dm.Take);
}
result.result = Data;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult UrlDataSource(Syncfusion.JavaScript.DataManager dm)
{
if (order.Count() == 0)
{
BindDataSource();
}
IEnumerable data = order.ToList();
// IEnumerable data = new NorthwindDataContext().OrdersViews.ToList();
DataOperations operation = new DataOperations();
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
data = operation.PerformSorting(data, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
data = operation.PerformWhereFilter(data, dm.Where, dm.Where[0].Operator);
}
if (dm.Search != null && dm.Search.Count > 0) //Searching
{
data = operation.PerformSearching(data, dm.Search);
}
if (dm.Select != null && dm.Select.Count > 0)
{
data = operation.PerformSelect(data, dm.Select);
}
var count = data.AsQueryable().Count();
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }));
}
public ActionResult BatchDataEditSMC(Syncfusion.JavaScript.DataManager dm, int?FacilityCode, string DateOfPhysicalCount)
{
DateTime vDate = DateTime.ParseExact(DateOfPhysicalCount, "dd/MM/yyyy", null);
IEnumerable Data = context.View_WebTemplate_SMC_SLM_PhysicalCount_Edit.Where(h => h.FacilityCode == FacilityCode && h.DateOfPhysicalCount == vDate).ToList();
DataResult result = new DataResult();
DataOperations operation = new DataOperations();
result.count = context.View_WebTemplate_SMC_SLM_PhysicalCount_Edit.Where(h => h.FacilityCode == FacilityCode && h.DateOfPhysicalCount == vDate).ToList().Count();
if (dm.Skip > 0)
{
Data = operation.PerformSkip(Data, dm.Skip);
}
if (dm.Take > 0)
{
Data = operation.PerformTake(Data, dm.Take);
}
result.result = Data;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult BatchData(Syncfusion.JavaScript.DataManager dm, int?Code)
{
context.Configuration.ProxyCreationEnabled = false;
IEnumerable Data = context.Order_DrugDetails_PhysicalCount.Where(a => a.product_code == Code).ToList();
DataResult result = new DataResult();
DataOperations operation = new DataOperations();
context.Configuration.ProxyCreationEnabled = false;
result.count = context.Order_DrugDetails_PhysicalCount.Where(a => a.product_code == Code).ToList().Count();
if (dm.Skip > 0)
{
Data = operation.PerformSkip(Data, dm.Skip);
}
if (dm.Take > 0)
{
Data = operation.PerformTake(Data, dm.Take);
}
result.result = Data;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetOrderTestSummary(Syncfusion.JavaScript.DataManager dm, string param_on)
{
TBModels obj = new TBModels();
IEnumerable data = obj.GetOrderTBSummary(param_on);
int count = obj.GetOrderTBSummary(param_on).Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetOrder(Syncfusion.JavaScript.DataManager dm, string param_on)
{
context.Configuration.ProxyCreationEnabled = false;
IEnumerable data = context.View_Order_TrackingModule_OrderDetails_1.Where(a => a.OrderNumber == param_on);
int count = context.View_Order_TrackingModule_OrderDetails_1.Where(a => a.OrderNumber == param_on).Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
//return Json(data, JsonRequestBehavior.AllowGet);
}
