public JsonResult AJXSearchRecipients()
{
int storeID = Session[Constant.SessionStoreID] != null?int.Parse(Session[Constant.SessionStoreID].ToString()) : -1;
string keyword = Request.Form["SearchKeyword"].ToString().Length < 1 ? null : Request.Form["SearchKeyword"];
int searchType = Request.Form["SearchType"] != null?int.Parse(Request.Form["SearchType"]) : -1;
var isActive = Request.Form["IsActive"] == "on";
int pageSize = int.Parse(ConfigurationManager.AppSettings["PageSize"]);
PagedList.IPagedList result = null;
int ddlStore = -1;
if (!String.IsNullOrEmpty(Request.Form["ddlStore"]) && !Libs.IsStore())
{
ddlStore = Request.Form["ddlStore"] != null?int.Parse(Request.Form["ddlStore"]) : -1;
}
if (Libs.IsStore())
{
ddlStore = storeID;
}
if (Libs.IsAdmin())
{
result = _storeService.GetListRecieverByStoreID(1, pageSize, ddlStore, keyword, searchType, isActive);
}
else
{
result = _storeService.GetListRecieverByStoreID(1, pageSize, ddlStore, keyword, searchType, isActive);
}
return(Json(RenderPartialViewToString("_RecieverGrid", result), JsonRequestBehavior.AllowGet));
}
public ActionResult ExportOrder(int storeID = -1, int wareHouseId = -1, string fromdate = null, string todate = null, int pageIndex = 1, int isActive = 1)
{
try
{
DateTime dtmFromdate = DateTime.Now.AddDays(-30);
DateTime dtmTodate = DateTime.Now;
if (fromdate != null)
{
dtmFromdate = DateTime.Parse(fromdate);
}
else
{
dtmFromdate = DateTime.Now.AddDays(-30);
}
if (todate != null)
{
dtmTodate = DateTime.Parse(todate);
}
else
{
dtmTodate = DateTime.Now;
}
if (Libs.IsStore())
{
storeID = int.Parse(Session[Constant.SessionStoreID].ToString());
}
var lsResult = _orderServices.getReportOrder(storeID, wareHouseId, dtmFromdate, dtmTodate, isActive, -1, 0); // lấy all
if (lsResult.Any())
{
XLWorkbook wb = new XLWorkbook();
wb.Worksheets.Add(MapTable(lsResult), "CurrencyTermRate");
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", $"attachment;filename={DateTime.Now:yyyyMMdd}_ReportOrder.xlsx");
using (MemoryStream myMemoryStream = new MemoryStream())
{
wb.SaveAs(myMemoryStream);
myMemoryStream.WriteTo(Response.OutputStream);
Response.End();
return(Content("Success"));
}
}
}
catch (Exception ex)
{
string test = ex.Message;
_logHelper.Info(ex);
}
return(RedirectToAction("ReportOrder"));
}
public ActionResult SearchOrder(PackageSearch model)
{
var result = new CustomJsonResult();
if (model.StoreId == 0)
{
model.StoreId = -1;
}
if (Libs.IsStore())
{
int tempInt = 1;
model.StoreId = int.TryParse(Session[Common.Constant.SessionStoreID].ToString(), out tempInt) ? int.Parse(Session[Common.Constant.SessionStoreID].ToString()) : -1;
}
var lstResult = _orderService.Admin_SearchPackage(model);// _orderService.Admin_SearchOrder(model);
lstResult.ForEach(x => { x.LstStatusCanChange = Compute_FilterOrderStatus(x); });
result.Result = lstResult;
result.Optional = model.Total;
return(Json(result));
}
public ActionResult _gridReportOrder(int storeID = -1, int wareHouseId = -1, string fromdate = null, string todate = null, int pageIndex = 1, int isActive = 1)
{
DateTime dtmFromdate = DateTime.Now.AddDays(-30);
DateTime dtmTodate = DateTime.Now;
if (fromdate != null)
{
dtmFromdate = DateTime.Parse(fromdate);
}
else
{
dtmFromdate = DateTime.Now.AddDays(-30);
}
if (todate != null)
{
dtmTodate = DateTime.Parse(todate);
}
else
{
dtmTodate = DateTime.Now;
}
List <ReportOrderModel> lsResult = new List <ReportOrderModel>();
pageIndex--;
if (Libs.IsStore())
{
storeID = int.Parse(Session[Constant.SessionStoreID].ToString());
}
lsResult = _orderServices.getReportOrder(storeID, wareHouseId, dtmFromdate, dtmTodate, isActive, pageSize, pageIndex);
if (lsResult != null && lsResult.Any())
{
ViewBag.TotalRows = lsResult.Count > 0 ? lsResult[0].TOTALROWS : 0;
ViewBag.Index = pageSize * (pageIndex - 1) + 1;
}
return(PartialView(lsResult));
}
