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