public static List <TblOrder> OrderList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblOrder.OrderBy(x => x.OrderDate).ToList()); } }
public static List <TblSlitting> PrimarySlittingList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblSlitting.OrderBy(x => x.SlittingDate).ToList()); } }
public static List <TblOrderStatus> OrderStatusList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblOrderStatus.OrderBy(x => x.Name).ToList()); } }
public static List <TblShiftType> ShiftTypeList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblShiftType.OrderBy(x => x.Name).ToList()); } }
public static List <TblProduct> ProductList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblProduct.OrderBy(x => x.FilmType).ToList()); } }
public static List <TblConsignee> ConsigneeList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblConsignee.OrderBy(x => x.Name).ToList()); } }
public static List <TblDispatch> DispatchListByInvoice(long?invoiceId) { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblDispatch.Include(m => m.TblInvoiceDetail).Where(m => m.TblInvoiceDetail.Any(y => y.InvoiceId == invoiceId)).OrderBy(x => x.DispatchNo).ToList()); } }
public static List <TblAuditSettings> ScreenList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblAuditSettings.OrderBy(x => x.ScreenName).ToList()); } }
public static List <TblRoles> RoleList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblRoles.OrderBy(x => x.RoleName).ToList()); } }
public static List <TblJumbo> JumboList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblJumbo.OrderBy(x => x.JumboDate).ToList()); } }
public IActionResult ResetPassword(ForgotPasswordModel userModel) { long id; if (userModel.ConfirmPassword != userModel.Password) { TempData[Enums.NotifyType.Error.GetDescription()] = "Password and Confirm Password must be same."; return(View("ResetPassword")); } TblUser model = _service.GetById(userModel.UserId); model.Password = EncryptionDecryption.GetEncrypt(userModel.Password); using (PolyFilmsContext contex = BaseContext.GetDbContext()) { model.Token = null; model.TokenExpiryDateTime = null; contex.TblUser.Update(model); id = contex.SaveChanges(); } if (id > 0) { TempData[Enums.NotifyType.Success.GetDescription()] = "Password reset successful."; return(View("Login", new LoginModel())); } TempData[Enums.NotifyType.Error.GetDescription()] = "Something went wrong. Please try again later."; return(View("ResetPassword")); }
public string UpdateRate(IEnumerable <InvoiceSlittingList> slittingList) { try { using (PolyFilmsContext context = BaseContext.GetDbContext()) { foreach (InvoiceSlittingList rate in slittingList) { TblSlitting currentModel = context.Set <TblSlitting>().Find(rate.SlittingId); currentModel.UnitPrice = rate.UnitPrice; currentModel.TotalPrice = rate.UnitPrice * currentModel.Netweight; _repository.Update(currentModel, context); } context.SaveChanges(); } return(string.Empty); } catch (Exception ex) { return(CommonHelper.GetErrorMessage(ex)); } }
public static bool CheckCoreAlreadyExists(string Name, decimal?thickness, short CoreId) { using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { return(dbContext.TblCore.Any(m => m.Name == Name && m.Thickness == thickness && m.CoreId != CoreId)); } }
public static bool CheckProductExistsINOrder(long OrderId, long ProductId, long OrderDetailId) { using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { return(dbContext.TblOrderDetail.Any(m => m.OrderId == OrderId && m.ProductId == ProductId && m.OrderDetailId != OrderDetailId)); } }
public static void LockSlittingData(string slittingIds) { using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { dbContext.LoadStoredProc("dbo.LockSlittingData").WithSqlParam("SlittingIds", slittingIds).ExecuteStoredProc <int>().FirstOrDefault(); } }
public static bool CheckProductExistsOrNot(string FilmType, decimal Thickness, long ProductId) { using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { return(dbContext.TblProduct.Any(m => m.FilmType == FilmType && m.Thickness == Thickness && m.ProductId != ProductId)); } }
public static List <TblTreatment> SlittingTreatmentList() { using (PolyFilmsContext _dbContext = BaseContext.GetDbContext()) { return(_dbContext.TblTreatment.OrderBy(x => x.Name).ToList()); } }
public static bool CheckRoleExistsOrNot(string RoleName, int RoleId) { using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { return(dbContext.TblRoles.Any(m => m.RoleName == RoleName && m.RoleId != RoleId)); } }
public static bool CheckConsigneeExistsOrNot(string GstNumber, string Pannumber, string contactnumber, long consigneeId) { using (PolyFilmsContext dbContext = BaseContext.GetDbContext()) { return(dbContext.TblConsignee.Any(m => m.Gstnumber == GstNumber && m.PanNumber == Pannumber && m.PhoneNumber == contactnumber && m.ConsigneeId != consigneeId)); } }
public static PolyFilmsContext GetDbContext() { var dbOptions = new DbContextOptionsBuilder <PolyFilmsContext>(); dbOptions.UseSqlServer(CommonHelper.ConnectionString); var dbContext = new PolyFilmsContext(dbOptions.Options); return(dbContext); }
/// <summary> /// /// </summary> public static void InitilizeSettings() { PolyFilmsContext context = BaseContext.GetDbContext(); List <TblSetting> settings = context.TblSetting.ToList(); foreach (TblSetting setting in settings) { switch (setting.KeyName) { case TblSetting.MailServerHost: MailServerHost = setting.Value; break; case TblSetting.MailServerPassword: MailServerPassword = setting.Value; break; case TblSetting.MailServerFromMail: MailServerFromMail = setting.Value; break; case TblSetting.MailServerPort: Int32.TryParse(setting.Value, out MailServerPort); break; case TblSetting.MailServerEnableSSL: MailServerEnableSsl = Convert.ToBoolean(setting.Value); break; case TblSetting.MailServerEmail: MailServerEmail = setting.Value; break; case TblSetting.SendErrorEmail: SendErrorEmail = Convert.ToBoolean(setting.Value); break; case TblSetting.ErrorEmail: ErrorEmail = setting.Value; break; case TblSetting.ReportServerURL: ReportServerURL = setting.Value; break; } } AuditSettings = context.TblAuditSettings.ToList(); EmailHelper.MailServerEmail = MailServerEmail; EmailHelper.MailServerHost = MailServerHost; EmailHelper.MailServerPort = MailServerPort; EmailHelper.MailServerPassword = MailServerPassword; EmailHelper.MailServerEnableSsl = MailServerEnableSsl; EmailHelper.MailServerFromMail = MailServerFromMail; }
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 <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 <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 <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()); }