public static List <OrderDetailsViewBO> GetOrders(string searchText, int LogcompanyID, string status, int coordinator, int distributor, int client, DateTime?selecteddate1, DateTime?selecteddate2, int distributorclientaddress) { using (IndicoEntities objContext = new IndicoEntities()) { System.Data.Objects.ObjectParameter recCount = new System.Data.Objects.ObjectParameter("P_RecCount", typeof(int)); List <OrderDetailsViewBO> lst = OrderDetailsViewBO.ToList(objContext.ViewOrderDetails(searchText, LogcompanyID, status, coordinator, distributor, client, selecteddate1, selecteddate2, distributorclientaddress)); return(lst); } }
public static List <OrderDetailsViewBO> GetWeeklyLessFiveItemOrders(DateTime?weekEndDate, string searchText, string OrderStatus, int sort, bool orderby, int set, int maxRows, out int total, string coordinator, string distributor, string client, int distributorclientaddress) { using (IndicoEntities objContext = new IndicoEntities()) { System.Data.Objects.ObjectParameter recCount = new System.Data.Objects.ObjectParameter("P_RecCount", typeof(int)); List <OrderDetailsViewBO> lst = OrderDetailsViewBO.ToList(objContext.GetWeeklyLessFiveItemOrders(weekEndDate, searchText, OrderStatus, sort, orderby, set, maxRows, recCount, coordinator, distributor, client, distributorclientaddress)); total = (int)recCount.Value; return(lst); } }
public static List <OrderDetailsViewBO> GetWeeklyHoldOrders(DateTime?weekEndDate, string searchText, string OrderStatus, string coordinator, string distributor, string client, int distributorclientaddress) { using (IndicoEntities objContext = new IndicoEntities()) { // System.Data.Objects.ObjectParameter recCount = new System.Data.Objects.ObjectParameter("P_RecCount", typeof(int)); List <OrderDetailsViewBO> lst = OrderDetailsViewBO.ToList(objContext.GetWeeklyHoldOrders(weekEndDate, searchText, OrderStatus, coordinator, distributor, client, distributorclientaddress)); //total = (int)recCount.Value; return(lst); } }