public ActionResult Export(RayonDatatableViewModel model)
{
MasterListBusiness business = new MasterListBusiness();
business.SetUserAuth(ViewBag.UserAuth);
AlertMessage alert = business.ExportMasterListSales(model);
if (alert.Status == 1)
{
var bytes = alert.Data as byte[];
return(File(bytes, System.Net.Mime.MediaTypeNames.Application.Octet, string.Format("MasterListSales-{0}.xlsx", DateTime.UtcNow.ToUtcID().ToString("yyyyMMdd-HHmm"))));
}
return(RedirectToAction("Index"));
}
public ActionResult DatatableRayon(RayonDatatableViewModel model)
{
if (!Request.IsAjaxRequest())
{
return(RedirectToAction("Index"));
}
JDatatableResponse resp = new JDatatableResponse();
HierSalesBusiness business = new HierSalesBusiness();
business.SetUserAuth(ViewBag.UserAuth);
resp = business.GetDatatableCustomer(model);
return(new MyJsonResult(resp, JsonRequestBehavior.AllowGet));
}
public ActionResult Datatable(RayonDatatableViewModel model)
{
if (!Request.IsAjaxRequest())
{
return(RedirectToAction("Index"));
}
JDatatableResponse resp = new JDatatableResponse();
MasterListBusiness business = new MasterListBusiness();
business.SetUserAuth(ViewBag.UserAuth);
resp = business.GetDatatableTagihByQuery(model);
return(new MyJsonResult(resp, JsonRequestBehavior.AllowGet));
}
public JDatatableResponse GetDatatableCustomer(RayonDatatableViewModel model)
{
JDatatableResponse result = new JDatatableResponse();
string[] arrOrderColumn = new string[] { "CreatedOn"
, "RayonCode"
, "CreatedOn"
, "CreatedOn"
, "Customer"
, "CustomerObj.CustomerName"
, "ValidFrom"
, "ValidTo" };
if (_userAuth == null)
{
return(result);
}
DateTime today = DateTime.UtcNow.ToUtcID().Date;
IRepository <RHDetail> repo = _unitOfWork.GetRepository <RHDetail>();
repo.Includes = new string[] { "CustomerObj" };
repo.Condition = PredicateBuilder.True <RHDetail>().And(x => x.RayonCode.Equals(model.RayonCode));
repo.Condition = repo.Condition.And(x => x.ValidTo >= today);
if (!string.IsNullOrEmpty(model.Keyword))
{
repo.Condition = repo.Condition.And(x => x.RayonCode.Contains(model.Keyword) ||
x.Customer.Contains(model.Keyword) ||
x.CustomerObj.CustomerName.Contains(model.Keyword));
}
SetDatatableRepository(model, arrOrderColumn, ref repo, ref result);
if (model.Length > -1 && result.TotalRecords == 0)
{
return(result);
}
List <RHDetail> listItem = repo.Find();
if (listItem == null)
{
return(result);
}
#region get salesman on a rayon
IRepository <RHHeader> repoRHH = _unitOfWork.GetRepository <RHHeader>();
repoRHH.Includes = new string[] { "SLMObj1" };
repoRHH.Condition = PredicateBuilder.True <RHHeader>().And(x => x.RayonCode.Equals(model.RayonCode) && x.ValidTo >= today);
repoRHH.OrderBy = new SqlOrderBy("CreatedOn", SqlOrderType.Descending);
RHHeader rhh = repoRHH.Find().FirstOrDefault();
#endregion
List <SalesCustomerViewModel> listData = new List <SalesCustomerViewModel>();
foreach (var item in listItem)
{
listData.Add(GetSalesRayonViewModel(item, rhh));
}
result.Data = listData;
return(result);
}
