public FrayteStatus GetSendMailStatus(int OperationZoneId)
{
FrayteStatus fs = new FrayteStatus();
//int OperationZoneId = UtilityRepository.GetOperationZone().OperationZoneId;
var item = dbContext.OperationZoneExchangeRates.Where(p => p.OperationZoneId == OperationZoneId).ToList();
if (item != null)
{
foreach (var Obj in item)
{
fs.CurrencyMailSentOn = Obj.MailSendOn == null?DateTime.Parse("01/01/0001") : Obj.MailSendOn.Value;
}
}
return(fs);
}
public FrayteStatus GetSendMailStatus(DateTime datetime, int OperationZoneId)
{
FrayteStatus fs = new FrayteStatus();
var item = dbcontext.FuelSurCharges.Where(p => p.OperationZoneId == OperationZoneId && p.FuelMonthYear.Year == datetime.Year && p.FuelMonthYear.Month == datetime.Month).FirstOrDefault();
if (item.MailSendOn.HasValue)
{
if (item.MailSendOn.Value == datetime)
{
}
else
{
fs.FuelMailSentOn = item.MailSendOn.Value;
}
}
return(fs);
}
public FrayteStatus ExchangeRateHistoryUpdateStatus()
{
FrayteStatus fs = new FrayteStatus();
//MM/dd/yyyy
DateTime dt = Frayte.Services.CommonConversion.ConvertToDateTime(DateTime.UtcNow.Month.ToString() + "/" + DateTime.UtcNow.Day.ToString() + "/" + DateTime.UtcNow.Year.ToString());
var item = dbContext.OperationZoneExchangeRateHistories.Where(p => p.FinishDate == dt.Date).ToList();
if (item != null && item.Count > 0)
{
fs.HistoryStatus = true;
}
else
{
fs.HistoryStatus = false;
}
return(fs);
}
public FrayteStatus UpdateStatus(DateTime datetime, int OperationZoneId)
{
FrayteStatus fs = new FrayteStatus();
//int OperationZoneId = UtilityRepository.GetOperationZone().OperationZoneId;
if (dbcontext.FuelSurCharges.Where(p => p.OperationZoneId == OperationZoneId && p.FuelMonthYear.Year == datetime.Year && p.FuelMonthYear.Month == datetime.Month).FirstOrDefault().UpdatedOn.HasValue)
{
DateTime updatedate = dbcontext.FuelSurCharges.Where(p => p.OperationZoneId == OperationZoneId && p.FuelMonthYear.Year == datetime.Year && p.FuelMonthYear.Month == datetime.Month).FirstOrDefault().UpdatedOn.Value;
if (updatedate >= datetime)
{
fs.IsFuelSurCharge = true;
return(fs);
}
else
{
int FuelId = dbcontext.FuelSurCharges.Where(p => p.OperationZoneId == OperationZoneId && p.FuelMonthYear.Year == datetime.Year && p.FuelMonthYear.Month == datetime.Month).FirstOrDefault().FuelSurChargeId;
var rs = dbcontext.FuelSurCharges.Where(p => p.FuelSurChargeId == FuelId).FirstOrDefault();
if (rs != null && rs.FuelSurChargeId > 0)
{
rs.MailSendOn = DateTime.UtcNow;
// Update
dbcontext.Entry(rs).State = System.Data.Entity.EntityState.Modified;
dbcontext.SaveChanges();
}
fs.IsFuelSurCharge = false;
return(fs);
}
}
else
{
int FuelId = dbcontext.FuelSurCharges.Where(p => p.OperationZoneId == OperationZoneId && p.FuelMonthYear.Year == datetime.Year && p.FuelMonthYear.Month == datetime.Month).FirstOrDefault().FuelSurChargeId;
var rs = dbcontext.FuelSurCharges.Where(p => p.FuelSurChargeId == FuelId).FirstOrDefault();
if (rs != null && rs.FuelSurChargeId > 0)
{
rs.MailSendOn = DateTime.UtcNow;
// Update
dbcontext.Entry(rs).State = System.Data.Entity.EntityState.Modified;
dbcontext.SaveChanges();
}
fs.IsFuelSurCharge = false;
return(fs);
}
}
