public object deleteFuelRecord(int id)
{
FuelRecord_Detail fuelDelete = dbCon.FuelRecord_Detail.SingleOrDefault(c => c.FuelRecord_DetailId == id);
dbCon.FuelRecord_Detail.Remove(fuelDelete);
dbCon.SaveChanges();
return("Data Deleted successfully.");
}
/// <summary>
///
/// </summary>
/// <param name="lstFuelRecodDto"></param>
/// <returns></returns>
public bool InsertFuelRecordDetail(List <FuelRecord_DetailDto> lstFuelRecodDto, int fuelId)
{
try
{
FuelRecord_Detail objFuelDetails;
//dbCon.FuelRecord_Detail.RemoveRange(dbCon.FuelRecord_Detail.Where(k => k.FuelRecordId == fuelId).ToList());
//dbCon.SaveChanges();
foreach (var item in lstFuelRecodDto)
{
objFuelDetails = new FuelRecord_Detail();
objFuelDetails.FuelRecordId = fuelId;
objFuelDetails.ActualMilage = item.ActualMilage;
objFuelDetails.AmountExVal = item.AmountExVal;
objFuelDetails.AmountInVal = item.AmountInVal.HasValue ? item.AmountInVal.Value : 0;
objFuelDetails.CurrentMilage = item.CurrentMilage;
objFuelDetails.Date = item.Date.HasValue ? item.Date.Value : System.DateTime.Now;
objFuelDetails.DateCreated = item.DateCreated;
objFuelDetails.Driver = item.Driver;
objFuelDetails.FillingStation = item.FillingStation;
objFuelDetails.FuelType = item.FuelType;
objFuelDetails.QuantityLitres = item.QuantityLitres;
objFuelDetails.VatAmount = item.VatAmount;
objFuelDetails.VoucherNumber = item.VoucherNumber;
objFuelDetails.CostCentreLocation = item.CostCentreLocation;
objFuelDetails.DiscountAmount = item.DiscountAmount;
objFuelDetails.RegistrationNo = string.IsNullOrEmpty(item.RegistrationNo) ? string.Empty : item.RegistrationNo;
dbCon.FuelRecord_Detail.Add(objFuelDetails);
}
dbCon.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
