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); }