public StatusResult InsertInspectionEntry(ManualRSI Rsi) { StatusResult c = new StatusResult(); try { if (!ModelState.IsValid) { var errors = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => x.Value.Errors.Select(y => y.ErrorMessage)).ToList(); Log.Error(Logfornet.LogMessage(Rsi.CompanyID, "InsertInspectionEntry", errors.ToArray(), "")); c.Status = Status.BadRequest.ToString(); c.Result = BadRequest(); return(c); } if (User.IsInRole(Roles.SuperAdmin) || User.IsInRole(Roles.PortalAdmin) || User.IsInRole(Roles.AccountAdmin)) { InspectionConfig InspectionConfig = new InspectionConfig(); Rsi.CreatedBy = ClaimsPrincipal.Current.FindFirst(ClaimTypes.NameIdentifier).Value; Rsi.ModifiedBy = ClaimsPrincipal.Current.FindFirst(ClaimTypes.NameIdentifier).Value; Rsi.CreatedOn = DateTime.Now; Rsi.ModifiedOn = DateTime.Now; var res = InspectionConfig.InsertInspectionEntry(Rsi); Log.Info(Logfornet.LogMessage(Rsi.CompanyID, "InsertInspectionEntry", ErrorMessages.Success, "")); c.Status = Status.Success.ToString(); c.Result = res; return(c); } else { Log.Warn(Logfornet.LogMessage(Rsi.CompanyID, "InsertInspectionEntry", ErrorMessages.NoAccessDenied, "")); c.Status = Status.NoAccess.ToString(); c.Result = "No Access"; return(c); } } catch (Exception ex) { Log.Error(Logfornet.LogMessage(Rsi.CompanyID, "InsertInspectionEntry", ex.Message, ex.StackTrace)); c.Status = ExceptionStatus.SqlException.ToString(); c.StatusCode = (int)ExceptionStatus.SqlException; c.Result = ex.InnerException; return(c); } }
public ManualRSI InsertInspectionEntry(ManualRSI Rsi) { if (IsActiveProfile && CheckDotExists(Rsi.DOTNumber, Rsi.CompanyID)) { var manualRsi = context.ManualRSIs.FirstOrDefault(x => x.CompanyID == Rsi.CompanyID && x.DOTNumber == Rsi.DOTNumber && x.InspectionDate == Rsi.InspectionDate && x.InspectionID == Rsi.InspectionID && x.DriverLicenseNumber == Rsi.DriverLicenseNumber); if (manualRsi == null) { var MRsi = new ManualRSI { CompanyID = Rsi.CompanyID, Comments = Rsi.Comments, CompanyVehicleNumber = Rsi.CompanyVehicleNumber, CreatedBy = Rsi.CreatedBy, CreatedOn = Rsi.CreatedOn, DisciplineActionIssued = Rsi.DisciplineActionIssued, DOTNumber = Rsi.DOTNumber, DriverFirstName = Rsi.DriverFirstName, DriverLastName = Rsi.DriverLastName, DriverLicenseNumber = Rsi.DriverLicenseNumber, DriverLicenseState = Rsi.DriverLicenseState, DriverLog = Rsi.DriverLog, InspectionDate = Rsi.InspectionDate, InspectionID = Rsi.InspectionID, InspectionReceived = Rsi.InspectionReceived, InspectionState = Rsi.InspectionState, ModifiedBy = Rsi.ModifiedBy, ModifiedOn = Rsi.ModifiedOn, NoticeNumber = Rsi.NoticeNumber, OOS = Rsi.OOS, OtherViolation = Rsi.OtherViolation, RepairWorkOrder = Rsi.RepairWorkOrder, ReportNumber = Rsi.ReportNumber, VehicleLicenseNumber = Rsi.VehicleLicenseNumber, Violations = Rsi.Violations, LocationCode = Rsi.LocationCode, DriverDOB = Rsi.DriverDOB, AdminNotes = Rsi.AdminNotes, INSP_ID = Rsi.INSP_ID }; context.ManualRSIs.Add(MRsi); context.SaveChanges(); return(MRsi); } else { manualRsi.Comments = Rsi.Comments; manualRsi.CompanyVehicleNumber = Rsi.CompanyVehicleNumber; manualRsi.DisciplineActionIssued = Rsi.DisciplineActionIssued; manualRsi.DriverFirstName = Rsi.DriverFirstName; manualRsi.DriverLastName = Rsi.DriverLastName; manualRsi.DriverLog = Rsi.DriverLog; manualRsi.InspectionReceived = Rsi.InspectionReceived; manualRsi.Violations = Rsi.Violations; manualRsi.RepairWorkOrder = Rsi.RepairWorkOrder; manualRsi.OtherViolation = Rsi.OtherViolation; manualRsi.InspectionState = Rsi.InspectionState; manualRsi.InspectionReceived = Rsi.InspectionReceived; manualRsi.LocationCode = Rsi.LocationCode; manualRsi.DriverDOB = Rsi.DriverDOB; manualRsi.AdminNotes = Rsi.AdminNotes; manualRsi.ModifiedBy = Rsi.ModifiedBy; manualRsi.ModifiedOn = Rsi.ModifiedOn; context.SaveChanges(); } return(manualRsi); } return(null); }
public ManualRSI InsertInspectionEntry(ManualRSI Rsi) { IRoadsideInspectionService InspectionInfo = new RoadsideInspectionService(Rsi.CompanyID); return(InspectionInfo.InsertInspectionEntry(Rsi)); }