public UserRolesModel(RoleManager <IdentityRole> roleManager,
CicotiWebApp.Data.ApplicationDbContext context, UserManager <ApplicationUser> userManager)
{
_roleManager = roleManager;
_context = context;
_userManager = userManager;
}
public JsonResult GetProvinceList(CicotiWebApp.Data.ApplicationDbContext _context, int CountryId)
{
List <Province> ProvinceList = _context.Provinces.Where(p => p.CountryID == CountryId).ToList();
JsonResult jsonProvinceList = new JsonResult(ProvinceList);
return(jsonProvinceList);
}
public ExcelImportExport(IHostingEnvironment hostingEnvironment,
CicotiWebApp.Data.ApplicationDbContext context)
{
_hostingEnvironment = hostingEnvironment;
_sWebRootFolder = _hostingEnvironment.WebRootPath;
_context = context;
}
public void PopulateCountryDropDownList(CicotiWebApp.Data.ApplicationDbContext _context,
object selectedCountry = null)
{
var CountryQuery = from c in _context.Countries
orderby c.CountryName
select c;
CountryNameSL = new SelectList(CountryQuery.AsNoTracking(),
"CountryID", "CountryName", selectedCountry);
}
public ExcelImportExport(String sfileName, IHostingEnvironment hostingEnvironment,
CicotiWebApp.Data.ApplicationDbContext context)
{
_hostingEnvironment = hostingEnvironment;
_sWebRootFolder = _hostingEnvironment.WebRootPath;
_sFileName = sfileName;
_context = context;
workbook = new XSSFWorkbook();
excelSheet = workbook.CreateSheet("Export");
}
public void PopulateProvinceDropDownList(CicotiWebApp.Data.ApplicationDbContext _context, int id,
object selectedProvince = null)
{
var ProvinceQuery = from c in _context.Provinces
where c.CountryID == id
orderby c.ProvinceName
select c;
ProvinceNameSL = new SelectList(ProvinceQuery.AsNoTracking(),
"ProvinceID", "ProvinceName", selectedProvince);
}
public UploadFilesController(IHostingEnvironment hostingEnvironment,
CicotiWebApp.Data.ApplicationDbContext context, IConfiguration configuration)
{
_hostingEnvironment = hostingEnvironment;
_configuration = configuration;
_context = context;
string folderName = "Upload";
string webRootPath = _hostingEnvironment.WebRootPath;
_newPath = Path.Combine(webRootPath, folderName);
// _virtualPathFolder = "~/Upload/";
if (!Directory.Exists(_newPath))
{
Directory.CreateDirectory(_newPath);
}
}
public DriverModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public LoadModel(CicotiWebApp.Data.ApplicationDbContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
_workFlowRule = new WorkFlowRule(_context, _userManager);
}
public AccountMovTableModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public StockCountSummaryModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public DestinationModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public SalesRepEmployeeModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public FindSKUModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public EmployeeModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
_empBusLayer = new EmployeeBusinessLayer();
}
public RoleStatusModel(CicotiWebApp.Data.ApplicationDbContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public WarehouseTableModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public StockCountListingModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public OutstandingPODModel(CicotiWebApp.Data.ApplicationDbContext context, IHostingEnvironment hostingEnvironment)
{
_context = context;
_hostingEnvironment = hostingEnvironment;
}
public LoadReportModel(CicotiWebApp.Data.ApplicationDbContext context, IHostingEnvironment hostingEnvironment)
{
_context = context;
_hostingEnvironment = hostingEnvironment;
}
public DeliveryStatusPivotModel(CicotiWebApp.Data.ApplicationDbContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public StaffAllocationItemModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public OtherIncomeTableModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public AllocationPerAccountModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public CreateModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public InsuranceTypeItemModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public IndexModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
}
public CreateModel(CicotiWebApp.Data.ApplicationDbContext context)
{
_context = context;
_vehicleBusLayer = new VehicleBusinessLayer();
}
