public ShipperCompanyResponse GetShipperList()
{
ShipperCompanyResponse shipperCompanyResponse = new ShipperCompanyResponse();
optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>();
using (var context = new ApplicationDbContext(optionsBuilder.Options))
{
try
{
shipperCompanyResponse.ShipperCompanies =
context.shipperCompanyRequests
.OrderByDescending(
(ShipperCompanyList shpCompany) => shpCompany.ID)
.ToList();
shipperCompanyResponse.Success = true;
return(shipperCompanyResponse);
}
catch (Exception ex)
{
shipperCompanyResponse.Success = false;
shipperCompanyResponse.OperatonExceptionMessage = ex.Message;
}
}
return(shipperCompanyResponse);
}
public ShipperCompanyService(ApplicationDbContext applicationDbContext)
{
this.context = applicationDbContext;
this.optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>();
this.optionsBuilder.EnableSensitiveDataLogging(true);
this.response = new ShipperCompanyResponse();
this.response.Success = true;
}
public ShipperCompanyResponse SelectShipperCompanies()
{
ShipperCompanyResponse shipperCompanyResponse = new ShipperCompanyResponse();
optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>();
using (var context = new ApplicationDbContext(optionsBuilder.Options))
{
try
{
shipperCompanyResponse.Success = true;
shipperCompanyResponse.ShipperCompanies = context.shipperCompanyRequests;
return(shipperCompanyResponse);
}
catch (Exception ex)
{
shipperCompanyResponse.Success = false;
shipperCompanyResponse.OperatonExceptionMessage = ex.Message;
}
}
return(shipperCompanyResponse);
}
public async Task <ActionResult> DeleteShipmentListById([FromBody] List <ShipperCompanyList> shipperCompanyRequests)
{
ShipperCompanyResponse shipperCompanyResponse = _shipperCompnayService.DeleteShipper(shipperCompanyRequests);
try
{
if (shipperCompanyResponse.Success)
{
// TO DO
}
else
{
// Log the error here
}
}
catch (Exception ex)
{
AuditEventEntry.WriteEntry(ex);
}
return(Ok(shipperCompanyResponse));
}
public ShipperCompanyResponse GetShipmentData()
{
ShipperCompanyResponse shipperCompanyResponse = this._shipperCompnayService.GetShipperList();
return(shipperCompanyResponse);
}
