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