public static int GetBatchId(string Batch)
{
using (var db = new RIT_QAEntities())
{
Batch ExistBatch = null;
var b = Batch;
try
{
ExistBatch = db.Batches.FirstOrDefault(x => x.BatchNumber == b);
}
catch (Exception ex)
{
Logger.Error("This should happend only when the Batch table is empty", ex);
}
int BatchId = 0;
// and create if it is new
if (ExistBatch == null)
{
Batch _currentBatch = db.Batches.Create();
_currentBatch.BatchNumber = Batch;
_currentBatch.Date = DateTime.Now;
db.Batches.Add(_currentBatch);
db.SaveChanges();
BatchId = _currentBatch.Id;
Logger.Debug("New batch created. Batch Number = " + _currentBatch.BatchNumber);
}
else
{
BatchId = ExistBatch.Id;
}
return(BatchId);
}
}
public void Save()
{
using (var db = new RIT_QAEntities())
{
try
{
db.Calibrations.Add(DpsDetails);
foreach (CalibrationData record in DataRecords)
{
db.CalibrationDatas.Add(record);
}
db.SaveChanges();
Logger.Debug("Calibrations saved");
}
catch (Exception ex)
{
Logger.Info("Save DPS calibration result failed.");
Logger.Error("", ex);
}
}
}
public void Save()
{
using (var db = new RIT_QAEntities())
{
try
{
if (this.EndDate == null)
{
this.EndDate = DateTime.Now;
}
db.ElectricalTests.Add(GetBase());
db.SaveChanges();
Logger.Debug("Test saved");
}
catch (Exception ex)
{
Logger.Info("Save DPS test result failed. Please that SErialNo, MAC and Result are field", ex);
Logger.Error("", ex);
}
}
}
