public int SaveInspectionReading( int inspection_detail_auto, int MeasurementPointId, String ToolCode, String Notes, MeasurementPointReading reading, int countReading) { //////////////////////////////////// // MEASUREMENT_POINT_RECORD DAL.MEASUREMENT_POINT_RECORD record = new DAL.MEASUREMENT_POINT_RECORD(); // FK ID record.InspectionDetailId = inspection_detail_auto; // FK ID record.CompartMeasurePointId = MeasurementPointId; // InboardOutboard record.InboardOutborad = 0; // ToolId TrackTool tool = new TrackTool(); int Id = -1; if (ToolCode != null) Id = tool.GetIdByToolCode(ToolCode); record.ToolId = Id; // Reading record.Reading = System.Convert.ToDecimal(reading.reading); // MeasureNumber record.MeasureNumber = reading.measureNo; // Worn BLL.Core.Domain.MiningShovelDomain.MeasurementPoint pointRecord = new MiningShovelDomain.MeasurementPoint(_context, MeasurementPointId); decimal worn = pointRecord.CalcWornPercentage( record.Reading.ConvertMMToInch(), record.ToolId, _Impact, MeasurementPointId ); record.Worn = worn; // Eval code char charEval = record.Worn.toEvalChar(); record.EvalCode = charEval.ToString(); // Notes if (countReading == 0) record.Notes = Notes; // INSERT _MEASUREMENT_POINT_RECORD.Add(record); _context.SaveChanges(); return record.Id; }
public Boolean SaveWSREComponentRecords( DAL.WSREComponentRecord record, WSREComponentRecordModel item) { // Comment record.Comment = item.Comment; // ComponentId record.ComponentId = item.ComponentId; // Measurement record.Measurement = item.Measurement; // MeasurementToolId TrackTool tool = new TrackTool(); int Id = tool.GetIdByToolCode(item.MeasurementToolId); record.MeasurementToolId = Id; // WornPercentage var component = new BLL.Core.Domain.Component(new UndercarriageContext(), Convert.ToInt32(record.ComponentId)); record.WornPercentage = component.CalcWornPercentage(record.Measurement.ConvertMMToInch(), record.MeasurementToolId, InspectionImpact.High); char charEval = record.WornPercentage.toEvalChar(); _overallEval = GetOverallEval(charEval, _overallEval); // INSERT _WSREComponentRecords.Add(record); _context.SaveChanges(); _arrComponentRecordId.Add(record.Id); ////////////////////////////////// // WSREComponentImages table foreach (var image in item.Images) { // ComponentrecordId DAL.WSREComponentImage imgRecord = new DAL.WSREComponentImage(); imgRecord.ComponentRecordId = record.Id; // Data byte[] imageData = GetUploadImageData(image.Data); imgRecord.Data = imageData; // Title imgRecord.Title = image.ImageTitle; // Comment imgRecord.Comment = image.ImageComment; // IncludeInReport imgRecord.IncludeInReport = true; // Deleted imgRecord.Deleted = false; // INSERT _WSREComponentImages.Add(imgRecord); } /////////////////////////////////////////////// // WSREComponentRecordRecommendations table foreach (var recommend in item.RecommendationId) { DAL.WSREComponentRecordRecommendation recommendRecord = new DAL.WSREComponentRecordRecommendation(); recommendRecord.ComponentRecordId = record.Id; recommendRecord.RecommendationId = recommend; // INSERT _WSREComponentRecordRecommendations.Add(recommendRecord); } return(true); }
public Boolean SaveAdditionalImages(AdditionalImage item) { //////////////////////////////////// // INSPECTION_COMPARTTYPE_RECORD DAL.INSPECTION_COMPARTTYPE_RECORD record = new DAL.INSPECTION_COMPARTTYPE_RECORD(); // FK ID record.CompartTypeAdditionalId = item.ServerId; // FK ID record.InspectionId = _InspectionAuto; // MeasureNumber record.MeasureNumber = 1; // ToolId TrackTool tool = new TrackTool(); int Id = -1; if (item.ToolCode.ToLower().Equals("observation")) { Id = tool.GetIdByToolCode("OB"); } else if (item.ToolCode.ToLower().Equals("yes/no")) { Id = tool.GetIdByToolCode("YES/NO"); } else { Id = tool.GetIdByToolCode("R"); } record.ToolId = Id; // Reading if (item.ToolCode.ToLower().Equals("observation")) { record.ObservationNote = item.Reading; } else { record.Reading = System.Convert.ToDecimal(item.Reading); } // Side record.Side = item.Side; // INSERT _INSPECTION_COMPARTTYPE_RECORD.Add(record); _context.SaveChanges(); ////////////////// // Image record if (item.ImageFileName == null || item.ImageFileName.Equals("")) return true; DAL.INSPECTION_COMPARTTYPE_RECORD_IMAGES recordImg = new DAL.INSPECTION_COMPARTTYPE_RECORD_IMAGES(); // FK recordImg.RecordId = record.Id; // FileName byte[] image = GetUploadImageData(item.ImageFileName); recordImg.Data = image; // Comment recordImg.Comment = item.ImageComment; // Title recordImg.Title = item.ImageTitle; // INSERT _INSPECTION_COMPARTTYPE_RECORD_IMAGES.Add(recordImg); return true; }