public string insertMaintenanceType(MaintenanceTypeDto maintenanceType)
{
GFI_AMM_VehicleMaintTypes maintType = new GFI_AMM_VehicleMaintTypes();
if (maintenanceType.MaintenanceTypeId != 0)
{
maintType = dbCon.GFI_AMM_VehicleMaintTypes.SingleOrDefault(c => c.MaintTypeId == maintenanceType.MaintenanceTypeId);
}
maintType.MaintCatId_cbo = maintenanceType.CategoryId;
maintType.Description = maintenanceType.Description;
maintType.OccurrenceEngineHrsTh = maintenanceType.EngineHrsBasedAlertThreshold;
maintType.OccurrenceEngineHrs = maintenanceType.EngineHrsBasedMaintenanceDue;
maintType.OccurrenceDuration = maintenanceType.OccurrenceDuration;
maintType.OccurrenceDurationTh = maintenanceType.TimeBasedAlertThreshold;
maintType.OccurrenceFixedDate = maintenanceType.OccurenceFixedDate;
maintType.OccurrenceFixedDateTh = maintenanceType.OccurenceFixedDateThreshold;
maintType.OccurrenceKM = maintenanceType.KMBasedMaintenanceDue;
maintType.OccurrenceKMTh = maintenanceType.KMBasedAlertThreshold;
maintType.OccurrencePeriod_cbo = maintenanceType.TimeBasedPeriod;
maintType.OccurrenceType = maintenanceType.IsFixedDateChecked == true?0:1;
maintType.One_Off = maintenanceType.One_Off;
maintType.UpdatedDate = System.DateTime.Now;
if (maintenanceType.MaintenanceTypeId == 0)
{
dbCon.GFI_AMM_VehicleMaintTypes.Add(maintType);
}
dbCon.SaveChanges();
return("");
}
public bool?SaveAssetMaintenance(int assestId, int maintenanceId)
{
try
{
if (!dbCon.AssetMaintenaceTypes.Any(x => x.AssetId == assestId && x.MaintenceId == maintenanceId))
{
int statusId = dbCon.GFI_AMM_VehicleMaintStatus.FirstOrDefault(d => d.Description.ToLower() == "to schedule").MaintStatusId;
AssetMaintenaceType obj = new AssetMaintenaceType();
obj.AssetId = assestId;
obj.MaintenceId = maintenanceId;
dbCon.AssetMaintenaceTypes.Add(obj);
GFI_AMM_VehicleMaintenance gfiMaitenceType = new GFI_AMM_VehicleMaintenance();
gfiMaitenceType.AssetId = assestId;
gfiMaitenceType.MaintTypeId_cbo = maintenanceId;
gfiMaitenceType.MaintStatusId_cbo = statusId;
gfiMaitenceType.CreatedDate = DateTime.Now;
dbCon.GFI_AMM_VehicleMaintenance.Add(gfiMaitenceType);
dbCon.SaveChanges();
return(true);
}
return(null);
}
catch (Exception ex)
{
return(false);
}
}
public string insertMaintenance(AssetMaintenanceDetailDto assetMaintenance)
{
try
{
//JavaScriptSerializer json_serializer = new JavaScriptSerializer();
//var json_serializer = new JavaScriptSerializer();
//List<lstPartDetails> routes_list = json_serializer.Deserialize<List<lstPartDetails>>(assetMaintenance.Parts);
GFI_AMM_VehicleMaintenance maint = dbCon.GFI_AMM_VehicleMaintenance.SingleOrDefault(c => c.URI == assetMaintenance.URI);///new GFI_AMM_VehicleMaintenance();
maint.ActualEngineHrs = assetMaintenance.ActualEngineHrs;
maint.ActualOdometer = assetMaintenance.ActualOdometer;
maint.AdditionalInfo = assetMaintenance.AdditionalInfo == "undefined" ? null : assetMaintenance.AdditionalInfo;
maint.AssetId = assetMaintenance.AssetId;
maint.AssetStatus = assetMaintenance.AssetStatus;
maint.CalculatedEngineHrs = assetMaintenance.CalculatedEngineHrs;
maint.CalculatedOdometer = assetMaintenance.CalculatedOdometer;
maint.Comment = assetMaintenance.Comment;
maint.CompanyName = assetMaintenance.CompanyName;
maint.CompanyRef = assetMaintenance.CompanyRef;
maint.ContactDetails = assetMaintenance.ContactDetails;
maint.CoverTypeId_cbo = assetMaintenance.CoverTypeId_cbo;
maint.EndDate = assetMaintenance.EndDate;
maint.EstimatedValue = assetMaintenance.EstimatedValue;
maint.MaintDescription = assetMaintenance.MaintDescription;
maint.MaintStatusId_cbo = assetMaintenance.MaintStatusId_cbo;
maint.MaintTypeId_cbo = assetMaintenance.MaintTypeId_cbo;
maint.PhoneNumber = assetMaintenance.PhoneNumber;
maint.StartDate = assetMaintenance.StartDate;
maint.TotalCost = assetMaintenance.TotalCost;
maint.VATAmount = assetMaintenance.VATAmount;
maint.VATInclInItemsAmt = assetMaintenance.VATInclInItemsAmt == "undefined" ? null : assetMaintenance.VATInclInItemsAmt;
maint.CreatedDate = DateTime.Now;
maint.UpdatedDate = DateTime.Now;
///var mainten= dbCon.GFI_AMM_VehicleMaintenance.Add(maint);
dbCon.SaveChanges();
dbCon.GFI_AMM_VehicleMaintItems.RemoveRange(dbCon.GFI_AMM_VehicleMaintItems.Where(x => x.MaintURI == maint.URI).ToList());
foreach (var item in assetMaintenance.lstParts)
//for (int i = 0; i < length; i++)
{
GFI_AMM_VehicleMaintItems mainItems = new GFI_AMM_VehicleMaintItems();
mainItems.CreatedDate = DateTime.Now;
mainItems.Description = item.Description;
mainItems.ItemCode = item.ItemCode;
mainItems.MaintURI = maint.URI;
mainItems.Quantity = item.Quantity;
mainItems.UnitCost = item.UnitCost;
mainItems.UpdatedDate = item.UpdatedDate;
dbCon.GFI_AMM_VehicleMaintItems.Add(mainItems);
dbCon.SaveChanges();
}
return(maint.URI.ToString());
}
catch (Exception ex)
{
return(string.Empty);
}
}
public int insertVatMaster(VatMasterDto vatadd)
{
try
{
GFI_FLT_VatMaster vat = new GFI_FLT_VatMaster();
vat.Vat = vatadd.Vat;
vat.StartDate = vatadd.StartDate.HasValue?vatadd.StartDate.Value : System.DateTime.Now;
vat.EndDate = vatadd.EndDate.HasValue?vatadd.EndDate.Value : System.DateTime.Now;
dbCon.GFI_FLT_VatMaster.Add(vat);
dbCon.SaveChanges();
return(vat.VatId);
}
catch (Exception)
{
throw;
return(0);
}
}
/// <summary>
/// Insert New Entry in Fuel Price Details DB Table
/// </summary>
/// <param name="objFuelMasterDto">Object of Model</param>
/// <returns>Success Or Failure</returns>
public bool InsertFuelRecord(FuelMasterDto objFuelMasterDto)
{
try
{
GFI_FuelDetail tblGFI_FuelDetail = new GFI_FuelDetail();
tblGFI_FuelDetail.Price = objFuelMasterDto.Price;
tblGFI_FuelDetail.Discount = objFuelMasterDto.Discount;
tblGFI_FuelDetail.Date = objFuelMasterDto.PriceDate;
tblGFI_FuelDetail.CreatedBy = objFuelMasterDto.CreatedBy;
tblGFI_FuelDetail.CreatedOn = DateTime.Now;
tblGFI_FuelDetail.Status = true;
tblGFI_FuelDetail.SupplierId = objFuelMasterDto.SupplierId;
dbCon.GFI_FuelDetail.Add(tblGFI_FuelDetail);
dbCon.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
/// <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);
}
}
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);
}
}
