public ActionResult CreateFuelRecord(FuelRecordDto fuel)
{
var obj = new FuelRecordRepo();
int statusLst = 0;
if (fuel.Id > 0)
{
if (obj.updateFuelRecord(fuel))
{
statusLst = fuel.Id;
}
}
else
{
statusLst = obj.InsertFuelRecord(fuel);
}
if (statusLst != 0)
{
FuelRecord_DetailRepo objDetail = new FuelRecord_DetailRepo();
bool result = objDetail.InsertFuelRecordDetail((TempData.Peek("lstFuelRecod") as List <FuelRecord_DetailDto>), statusLst);
TempData.Remove("lstFuelRecod");
return(Json("Record saved successfully."));
}
else
{
return(Json("Something went wrong."));
}
}
public bool updateFuelRecord(FuelRecordDto fuel)
{
try
{
var ful = dbCon.Fuel_Record.Where(x => x.Id == fuel.Id).FirstOrDefault();
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;
dbCon.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
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);
}
}
