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());
}
