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)); }