public ActionResult ListJson(JqGridRequest request) { var categoryMapping = CategoryMappingBL.GetAllAsQueryable(); JqGridData result = JqGridHelper<CategoryMapping>.ToJqGridData(request, categoryMapping, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.MalGrupID, c.MalGrupName, c.DepartmentID, c.DepartmentName, c.PurchasingGroupID, c.PurchasingGroupName, c.GenderCode, c.TargetCategoryCodes, c.IsColorProductLevel, c.MainCategoryAttributeCode, c.SubCategoryAttributeCode, c.GoogleCategoryMain, c.GoogleCategorySub1, c.GoogleCategorySub2, c.GoogleCategorySub3, c.GoogleCategorySub4, c.GoogleCategorySub5, c.GoogleCategorySub6, c.SizeTableFriendlyUri } }); return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult ListJson(JqGridRequest request) { var colorMappingList = ColorMappingBL.GetAllAsQueryable(); JqGridData result = JqGridHelper<ColorMapping>.ToJqGridData(request, colorMappingList, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.Color, c.GroupName } }); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult ListJson(JqGridRequest request) { IQueryable<vCollectionPackagingCenter> list = CollectionPackagingCenterBL.GetAllStoreLocationListAsQueryable(); JqGridData result = JqGridHelper<vCollectionPackagingCenter>.ToJqGridData(request, list, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.CollectionCenterName, c.PackagingCenterName, c.CityCode, } }); return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult LocationFailedItemsToExcel(JqGridRequest request) { IQueryable<vOrderItem> list = CheckoutBL.GetLocationSuggestionFailedList(); var result = JqGridExtensions.ListAddSearchQuery(list, request).Select(c => new { c.ID, c.ItemIdentifier, c.OrderCode, c.VariantCode, c.LocationSuggestionProblemText }); string[] columnNames = { "ID", "Varyant Tanım ID", "Sipariş Kodu", "Varyant Kodu", "Lokasyon Bulanamama Sebebi" }; byte[] excelByteArray = ExcelExport.ExportToExcel(ExcelExport.ToDataTable(result), columnNames, "Lokasyon Atanamayan Ürünler"); return File(excelByteArray, "application/vnd.ms-excel", "Lokasyon Atanamayan Ürünler.xls"); }
public JsonResult LocationFailedItems(JqGridRequest request) { IQueryable<vOrderItem> list = CheckoutBL.GetLocationSuggestionFailedList(); JqGridData result = JqGridHelper<vOrderItem>.ToJqGridData(request, list, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.ItemIdentifier, c.OrderCode, c.VariantCode, c.LocationSuggestionProblemText } }); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult ListJson(JqGridRequest request) { List<UserLocationDO> lst = UserLocationBL.GetAll().ToList(); IQueryable<UserLocationDO> userSettingList = lst.AsQueryable(); JqGridData result = JqGridHelper<UserLocationDO>.ToJqGridData(request, userSettingList, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.UserName, c.LocationCode, c.LocationName } }); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult ListJson(JqGridRequest request) { List<LocationDO> lst = LocationBL.GetAllLocations().ToList(); IQueryable<LocationDO> userSettingList = lst.AsQueryable(); JqGridData result = JqGridHelper<LocationDO>.ToJqGridData(request, userSettingList, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.Name, c.Code, c.Priority, c.IsCollectionLocation, c.IsPackagingLocation } }); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult OrderItemListJson(JqGridRequest request) { IQueryable<vOrderItem> list = CheckoutBL.GetAllvOrderItemsAsQueryable(); JqGridData result = JqGridHelper<vOrderItem>.ToJqGridData(request, list, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.ItemIdentifier, c.OrderCode, c.VariantCode, c.Barcode, c.Brand, c.Color, c.Size, c.ProductType, c.PurchasingGroup, c.StatusCode, GetFormattedDate(c.StatusCodeUpdateTime), c.CollectionLocationCode, c.CollectionLocationName, c.PackagingLocationCode, c.PackagingLocationName, c.WaybillNumber, GetFormattedDate(c.CreateTime), GetUserName(c.WaitingOnUserID), GetFormattedDate(c.WaitingOnUserUpdateTime), c.Year, c.Season, c.IsTransferred, c.IsPreOrder } }); return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult ListExportToExcel(JqGridRequest request, string filter) { var categoryMappingList = CategoryMappingBL.GetAllAsQueryable(); var result = JqGridExtensions.ListAddSearchQuery(categoryMappingList, request).Select(c => new { c.ID, c.MalGrupID, c.MalGrupName, c.DepartmentID, c.DepartmentName, c.PurchasingGroupID, c.PurchasingGroupName, c.GenderCode, c.TargetCategoryCodes, c.IsColorProductLevel, c.MainCategoryAttributeCode, c.SubCategoryAttributeCode, c.GoogleCategoryMain, c.GoogleCategorySub1, c.GoogleCategorySub2, c.GoogleCategorySub3, c.GoogleCategorySub4, c.GoogleCategorySub5, c.GoogleCategorySub6 }); string[] columnNames = {"ID", "Mal Grubu ID", "Mal Grubu Adı", "Departman ID" , "Departman Adı", "Satın Alma Grubu ID", "Satın Alma Grubu Adı" , "Cinsiyet Kodu", "Hedef Kategori Kodu", "Her Renk Ayrı Ürün mü" , "Ana Kategori Attribute Kodu", "Alt Kategori Attribute Kodu" , "Google Ana Kategorisi", "Google Alt Kategori 1", "Google Alt Kategori 2", "Google Alt Kategori 3" , "Google Alt Kategori 4", "Google Alt Kategori 5", "Google Alt Kategori 6"}; byte[] excelByteArray = ExcelExport.ExportToExcel(ExcelExport.ToDataTable(result), columnNames, "Kampanya Listesi"); return File(excelByteArray, "application/vnd.ms-excel", "Kampanya Listesi.xls"); }
public ActionResult OrderItemListExcel(JqGridRequest request) { IQueryable<vOrderItem> list = CheckoutBL.GetAllvOrderItemsAsQueryable(); var result = JqGridExtensions.ListAddSearchQuery(list, request).Select(c => new { c.ID, c.ItemIdentifier, c.OrderCode, c.VariantCode, c.Barcode, c.Brand, c.Color, c.Size, c.ProductType, c.PurchasingGroup, c.StatusCode, c.CollectionLocationName, c.PackagingLocationName, c.WaybillNumber, CreateTime = GetFormattedDate(c.CreateTime) }); string[] columnNames = { "ID", "Varyant Tanım ID", "Sipariş Kodu", "Varyant Kodu", "Barkod", "Marka", "Renk", "Beden", "Tipi", "Grubu", "Durumu", "Toplama Merk.", "Paketleme Merk.", "İrsaliye No", "Tarih"}; byte[] excelByteArray = ExcelExport.ExportToExcel(ExcelExport.ToDataTable(result), columnNames, "Sipariş Kalemleri"); return File(excelByteArray, "application/vnd.ms-excel", "Sipariş Kalemleri.xls"); }
public JsonResult HistoryListJson(JqGridRequest request, string filter) { IQueryable<vCollectionData> list = CollectionDataBL.GetPickupHistoryList(base.UserID, filter); JqGridData result = JqGridHelper<vCollectionData>.ToJqGridData(request, list, c => new JqGridRowItem { id = c.ID, cell = new object[] { c.ID, c.LocationName, base.GetFormattedTime(c.CreateTime), base.GetFormattedTime(c.UpdateTime), UserBL.GetUserFullNameUsingID(c.CreateUserID) } }); return Json(result, JsonRequestBehavior.AllowGet); }