public DTO.StockRemains QuickSearchStockRemain(int userID, Hashtable filters, out Library.DTO.Notification notification) { DTO.StockRemains data = new DTO.StockRemains(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; int totalRows = 0; //search info string articleCode = string.Empty; string description = string.Empty; int? factoryID = null; if (filters.ContainsKey("articleCode")) { articleCode = filters["articleCode"].ToString(); } if (filters.ContainsKey("description")) { description = filters["description"].ToString(); } if (filters.ContainsKey("factoryID") && filters["factoryID"] != null) { factoryID = Convert.ToInt32(filters["factoryID"].ToString()); } //pager info int pageSize = 20; int pageIndex = 1; string sortedBy = string.Empty; string sortedDirection = string.Empty; if (filters.ContainsKey("pageSize")) { pageSize = Convert.ToInt32(filters["pageSize"].ToString()); } if (filters.ContainsKey("pageIndex")) { pageIndex = Convert.ToInt32(filters["pageIndex"].ToString()); } if (filters.ContainsKey("sortedBy")) { sortedBy = filters["sortedBy"].ToString(); } if (filters.ContainsKey("sortedDirection")) { sortedDirection = filters["sortedDirection"].ToString(); } try { using (FactoryStockReceiptEntities context = CreateContext()) { totalRows = context.FactoryStockReceiptMng_function_QuickSearchStockRemain(sortedBy, sortedDirection, articleCode, description, factoryID, userID).Count(); var result = context.FactoryStockReceiptMng_function_QuickSearchStockRemain(sortedBy, sortedDirection, articleCode, description, factoryID, userID); data.Data = converter.DB2DTO_StockRemain(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); data.TotalRows = totalRows; } return(data); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(data); } }
public DTO.StockRemains QuickSearchStockRemain(Hashtable filters, out Library.DTO.Notification notification) { DTO.StockRemains data = new DTO.StockRemains(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; int totalRows = 0; //search info string factoryMaterialUD = string.Empty; string factoryMaterialNM = string.Empty; string factoryFinishedProductUD = string.Empty; string factoryFinishedProductNM = string.Empty; string articleCode = string.Empty; string description = string.Empty; string clientUD = string.Empty; string proformaInvoiceNo = string.Empty; int? factoryMaterialID = null; int? factoryAreaID = null; int? factoryTeamID = null; if (filters.ContainsKey("factoryMaterialUD")) { factoryMaterialUD = filters["factoryMaterialUD"].ToString(); } if (filters.ContainsKey("factoryMaterialNM")) { factoryMaterialNM = filters["factoryMaterialNM"].ToString(); } if (filters.ContainsKey("factoryFinishedProductUD")) { factoryFinishedProductUD = filters["factoryFinishedProductUD"].ToString(); } if (filters.ContainsKey("factoryFinishedProductNM")) { factoryFinishedProductNM = filters["factoryFinishedProductNM"].ToString(); } if (filters.ContainsKey("articleCode")) { articleCode = filters["articleCode"].ToString(); } if (filters.ContainsKey("description")) { description = filters["description"].ToString(); } if (filters.ContainsKey("clientUD")) { clientUD = filters["clientUD"].ToString(); } if (filters.ContainsKey("proformaInvoiceNo")) { proformaInvoiceNo = filters["proformaInvoiceNo"].ToString(); } if (filters.ContainsKey("factoryMaterialID") && filters["factoryMaterialID"] != null) { factoryMaterialID = Convert.ToInt32(filters["factoryMaterialID"]); } if (filters.ContainsKey("factoryAreaID") && filters["factoryAreaID"] != null) { factoryAreaID = Convert.ToInt32(filters["factoryAreaID"]); } if (filters.ContainsKey("factoryTeamID") && filters["factoryTeamID"] != null) { factoryTeamID = Convert.ToInt32(filters["factoryTeamID"]); // factory team allway set when type is export } //pager info int pageSize = 20; int pageIndex = 1; string sortedBy = string.Empty; string sortedDirection = string.Empty; if (filters.ContainsKey("pageSize")) { pageSize = Convert.ToInt32(filters["pageSize"].ToString()); } if (filters.ContainsKey("pageIndex")) { pageIndex = Convert.ToInt32(filters["pageIndex"].ToString()); } if (filters.ContainsKey("sortedBy")) { sortedBy = filters["sortedBy"].ToString(); } if (filters.ContainsKey("sortedDirection")) { sortedDirection = filters["sortedDirection"].ToString(); } try { using (FactoryMaterialReceiptEntities context = CreateContext()) { totalRows = context.FactoryMaterialReceiptMng_function_QuickSearchStockRemain(sortedBy, sortedDirection, factoryMaterialUD, factoryMaterialNM, factoryFinishedProductUD, factoryFinishedProductNM, articleCode, description, clientUD, proformaInvoiceNo, factoryMaterialID, factoryAreaID, factoryTeamID).Count(); var result = context.FactoryMaterialReceiptMng_function_QuickSearchStockRemain(sortedBy, sortedDirection, factoryMaterialUD, factoryMaterialNM, factoryFinishedProductUD, factoryFinishedProductNM, articleCode, description, clientUD, proformaInvoiceNo, factoryMaterialID, factoryAreaID, factoryTeamID); data.Data = converter.DB2DTO_StockRemain(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); data.TotalRows = totalRows; } return(data); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(data); } }