public string deleteFuelManagement(int id)
{
dbCon.FuelRecord_Detail.RemoveRange(dbCon.FuelRecord_Detail.Where(k => k.FuelRecordId == id).ToList());
dbCon.SaveChanges();
Fuel_Record fuelDelete = dbCon.Fuel_Record.SingleOrDefault(c => c.Id == id);
dbCon.Fuel_Record.Remove(fuelDelete);
dbCon.SaveChanges();
return("Data Deleted successfully.");
}
public int InsertFuelRecord(FuelRecordDto fuel)
{
try
{
Fuel_Record ful = new Fuel_Record();
ful.FillingStation = fuel.FillingStation;
ful.SupplierCode = fuel.SupplierCode;
ful.SupplierName = fuel.SupplierName;
ful.ClaimNumber = fuel.ClaimNumber;
ful.InvoiceNo = fuel.InvoiceNo;
ful.InvoiceDate = fuel.InvoiceDate;
ful.PaymentCertNo = fuel.PaymentCertNo;
ful.Period = fuel.Period;
ful.DiscountAmountPetrol = fuel.DiscountAmountPetrol;
ful.DiscountAmountDiesel = fuel.DiscountAmountDiesel;
ful.DiscountAmountGasoline = fuel.DiscountAmountGasoline;
ful.InvoiceDiscountAmount = fuel.InvoiceDiscountAmount;
ful.RegistrationNo = fuel.RegistrationNo;
ful.InvoiceTotalAmount = fuel.InvoiceTotalAmount;
ful.InvoiceVatAmount = fuel.InvoiceVatAmount;
ful.AmountPetrolLt = fuel.AmountPetrolLt;
ful.AmountDieselLt = fuel.AmountDieselLt;
ful.AmountGasolineLt = fuel.AmountGasolineLt;
ful.Is_PaymentReceiptGenerate = fuel.Is_PaymentReceiptGenerate;
ful.Is_Excel = fuel.Modeofupload == 0 ? true : false;
dbCon.Fuel_Record.Add(ful);
dbCon.SaveChanges();
return(ful.Id);
}
catch (Exception)
{
throw;
return(0);
}
}
