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 bool deleteMaintType(int id)
{
GFI_AMM_VehicleMaintenance deletemtype = dbCon.GFI_AMM_VehicleMaintenance.Where(c => c.MaintTypeId_cbo == id && c.UpdatedDate == null).FirstOrDefault();
if (deletemtype == null)
{
return(false);
}
else
{
dbCon.AssetMaintenaceTypes.RemoveRange(dbCon.AssetMaintenaceTypes.Where(c => c.MaintenceId == id));
dbCon.SaveChanges();
GFI_AMM_VehicleMaintTypes maintType = dbCon.GFI_AMM_VehicleMaintTypes.SingleOrDefault(c => c.MaintTypeId == id);
dbCon.GFI_AMM_VehicleMaintTypes.Remove(maintType);
dbCon.SaveChanges();
}
return(true);
}
