public IHttpActionResult SaveFuelSurCharge(FrayteFuelSurChargeSaveModel FrayteSurCharge)
{
FuelSurChargeRepository fscr = new FuelSurChargeRepository();
FrayteResult result = fscr.SaveFuelSurCharge(FrayteSurCharge);
return(Ok(result));
}
public FrayteResult SaveFuelSurCharge(FrayteFuelSurChargeSaveModel FrayteSurCharge)
{
FrayteResult result = new FrayteResult();
try
{
FrayteSurCharge.Year = new DateTime(FrayteSurCharge.Year.Year, 1, FrayteSurCharge.Year.Day);
FuelSurCharge fuelsurcharge;
var service = dbcontext.LogisticServices.Where(p => p.OperationZoneId == FrayteSurCharge.OperationZoneId && p.IsActive == true).ToList();
if (service.Count > 0)
{
foreach (var ss in service)
{
fuelsurcharge = new FuelSurCharge();
for (int i = 1; i <= 12; i++)
{
fuelsurcharge.OperationZoneId = FrayteSurCharge.OperationZoneId;
fuelsurcharge.LogisticServiceId = ss.LogisticServiceId;
fuelsurcharge.FrayteFuelPercent = 0;
fuelsurcharge.ExpryesFuelPercent = 0;
fuelsurcharge.DomesticFuelPercent = 0;
fuelsurcharge.RoadFuelSurcharge = 0;
fuelsurcharge.FuelMonthYear = FrayteSurCharge.Year;
fuelsurcharge.CreatedOn = DateTime.UtcNow;
fuelsurcharge.UpdatedOn = null;
fuelsurcharge.UpdatedBy = 1;
fuelsurcharge.IsUpdated = true;
dbcontext.FuelSurCharges.Add(fuelsurcharge);
dbcontext.SaveChanges();
FrayteSurCharge.Year = FrayteSurCharge.Year.AddMonths(1);
}
}
}
result.Status = true;
}
catch (Exception ex)
{
result.Status = false;
}
return(result);
}
public List <FuelSurChargeModel> SaveFuelCharge(int OperationZoneId, DateTime Year, string LogisticCompany)
{
FrayteFuelSurChargeSaveModel FrayteSurCharge = new FrayteFuelSurChargeSaveModel();
var result = GetDistinctLogisticCompany(OperationZoneId);
FrayteSurCharge.OperationZoneId = OperationZoneId;
FrayteSurCharge.Year = Year;
SaveFuelSurCharge(FrayteSurCharge);
List <FrayteFuelSurChargeList> _fuel = new List <FrayteFuelSurChargeList>();
FrayteFuelSurChargeList _fuelssur = new FrayteFuelSurChargeList();
_fuelssur.FuelSurCharge = new List <FuelSurChargeModel>();
try
{
if (Year.Month == 1)
{
var Company = LogisticCompany;
for (int i = 0; i < 3; i++)
{
if (i == 0)
{
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == Year.Month && r.FuelMonthYear.Year == Year.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
//_fuelssur.LogisticCompany = data.LogisticCompany;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
else if (i == 1)
{
DateTime month = Year.AddMonths(-1);
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == month.Month && r.FuelMonthYear.Year == month.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
else if (i == 2)
{
DateTime month = Year.AddMonths(-2);
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == month.Month && r.FuelMonthYear.Year == month.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
}
}
else if (Year.Month == 2)
{
var Company = LogisticCompany;
for (int i = 0; i < 3; i++)
{
if (i == 0)
{
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == Year.Month && r.FuelMonthYear.Year == Year.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
//_fuelssur.LogisticCompany = data.LogisticCompany;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
else if (i == 1)
{
DateTime month = Year.AddMonths(-1);
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == month.Month && r.FuelMonthYear.Year == month.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
else if (i == 2)
{
DateTime month = Year.AddMonths(-2);
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == month.Month && r.FuelMonthYear.Year == month.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
}
}
else
{
var Company = LogisticCompany;
for (int i = 0; i < 3; i++)
{
if (i == 0)
{
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == Year.Month && r.FuelMonthYear.Year == Year.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
//_fuelssur.LogisticCompany = data.LogisticCompany;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
else if (i == 1)
{
DateTime month = Year.AddMonths(-1);
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == month.Month && r.FuelMonthYear.Year == month.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
else if (i == 2)
{
DateTime month = Year.AddMonths(-2);
var data = dbcontext.FuelSurCharges.Where(r => r.OperationZoneId == OperationZoneId && r.FuelMonthYear.Month == month.Month && r.FuelMonthYear.Year == month.Year).FirstOrDefault();
if (data != null)
{
FuelSurChargeModel fuel = new FuelSurChargeModel();
fuel.FuelSurchargeId = data.FuelSurChargeId;
fuel.FrayteFuelPercent = data.FrayteFuelPercent.ToString();
fuel.ExpryeFuelPercent = data.ExpryesFuelPercent.ToString();
fuel.DomesticFuelPercent = data.DomesticFuelPercent.ToString();
fuel.RoadFuelPercent = data.RoadFuelSurcharge.ToString();
fuel.FuelMonthYear = data.FuelMonthYear;
_fuelssur.FuelSurCharge.Add(fuel);
}
}
}
}
return(_fuelssur.FuelSurCharge.OrderBy(x => x.FuelMonthYear).ToList());
}
catch (Exception ex)
{
return(null);
}
}
