public static void LockSlittingData(string slittingIds) { using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dbContext.LoadStoredProc("dbo.LockSlittingData").WithSqlParam("SlittingIds", slittingIds).ExecuteStoredProc <int>().FirstOrDefault(); } }
public static List <PendingProductionDataModel> GetPendingProductionList() { IList <PendingProductionDataModel> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetPendingProductionData").ExecuteStoredProc <PendingProductionDataModel>(); } return(dataList.OrderByDescending(m => m.Pending).ToList()); }
public static List <JumboRollStockModel> GetJumboRollStockList() { IList <JumboRollStockModel> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetJumboRollStockData").ExecuteStoredProc <JumboRollStockModel>(); } return(dataList.OrderBy(m => m.JumboDate).ToList()); }
public static List <InvoiceSlittingList> GetInvoiceSlittingList(long?dispatchId = null) { IList <InvoiceSlittingList> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetSlittingListByDispatchId") .WithSqlParam("dispatchId", dispatchId) .ExecuteStoredProc <InvoiceSlittingList>(); } return(dataList.OrderBy(m => m.OrderNo).ToList()); }
public static List <UserRightsModel> GetUserRightsList(int roleId) { IList <UserRightsModel> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.AssignRoleList") .WithSqlParam("RoleId", roleId) .ExecuteStoredProc <UserRightsModel>(); } return(dataList.ToList()); }
public static TotalAmountModel GetTotalAmountForInvoice(string listofDispatchId) { TotalAmountModel totalAmount; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { totalAmount = dbContext.LoadStoredProc("dbo.GetTotalAmountForInvoice") .WithSqlParam("lostOfDispatchId", listofDispatchId) .ExecuteStoredProc <TotalAmountModel>().FirstOrDefault(); } return(totalAmount); }
public static List <UserAccessPermission> UserAccessPermissions(int?roleId = null, bool isSuperAdmin = false) { IList <UserAccessPermission> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.Get_UserAccessPermissions") .WithSqlParam("RoleId", roleId) .WithSqlParam("IsSuperAdmin", isSuperAdmin) .ExecuteStoredProc <UserAccessPermission>(); } return(dataList.OrderBy(m => m.MenuName).ToList()); }
public static List <SalesOrderModel> GetSalesOrderDetailByOrderId(long orderId, short productId) { IList <SalesOrderModel> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetSalesOrderDetailByOrder") .WithSqlParam("OrderId", orderId) .WithSqlParam("ProductId", productId) .ExecuteStoredProc <SalesOrderModel>(); } return(dataList.OrderByDescending(m => m.DispatchDate).ToList()); }
public static List <SalesOrderDetailModel> GetSalesOrderDetailList(int?month = null, int?year = null) { IList <SalesOrderDetailModel> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetSalesOrderDetail") .WithSqlParam("month", month) .WithSqlParam("year", year) .ExecuteStoredProc <SalesOrderDetailModel>(); } return(dataList.OrderBy(m => m.OrderDate).ToList()); }
public static List <DispatchOrderList> GetDispatchOrderList(long buyerId, long consigneeId, long productId) { IList <DispatchOrderList> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetOrderForDispatchSlitting") .WithSqlParam("buyerId", buyerId) .WithSqlParam("consigneeId", consigneeId) .WithSqlParam("productId", productId) .ExecuteStoredProc <DispatchOrderList>(); } return(dataList.OrderBy(m => m.OrderDate).ToList()); }
public static List <DispatchSlittingList> GetDispatchSlittingList(long?buyerId = null, long?consigneeId = null, long?DispatchId = null, bool?IsFinalize = false) { IList <DispatchSlittingList> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetDispatchSlittingList") .WithSqlParam("BuyerId", buyerId) .WithSqlParam("ConsigneeId", consigneeId) .WithSqlParam("DispatchId", DispatchId) .WithSqlParam("IsFinalize", IsFinalize) .ExecuteStoredProc <DispatchSlittingList>(); } return(dataList.OrderBy(m => m.SlittingDate).ToList()); }
public static List <InvoiceDispatchList> GetInvoiceDispatchList(long?customerId = null, long?consigneeId = null, long?invoiceId = null, bool?isFinalize = false) { IList <InvoiceDispatchList> dataList; using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dataList = dbContext.LoadStoredProc("dbo.GetInvoiceDispatchList") .WithSqlParam("CustomerId", customerId) .WithSqlParam("ConsigneeId", consigneeId) .WithSqlParam("InvoiceId", invoiceId) .WithSqlParam("IsFinalize", isFinalize) .ExecuteStoredProc <InvoiceDispatchList>(); } return(dataList.OrderBy(m => m.DispatchDate).ToList()); }