public static Batch GetCalibrationBatch(string SerialNo)
{
using (var db = new RIT_QAEntities())
{
Batch batch = db.Calibrations.FirstOrDefault(x => x.SerialNo == SerialNo).Batch;
db.Entry(batch).State = System.Data.Entity.EntityState.Detached;
return(batch);
}
}
public static Calibration GetDpsInfo(string SerialNo)
{
using (var db = new RIT_QAEntities())
{
Calibration dps = db.Calibrations.FirstOrDefault(x => x.SerialNo == SerialNo);
db.Entry(dps).State = System.Data.Entity.EntityState.Detached;
return(dps);
}
}
public static List <CalibrationData> GetCalibrationData(string SerialNo)
{
List <CalibrationData> list = new List <CalibrationData>();
using (var db = new RIT_QAEntities())
{
foreach (CalibrationData data in db.Calibrations.FirstOrDefault(x => x.SerialNo == SerialNo).CalibrationDatas.ToList())
{
db.Entry(data).State = System.Data.Entity.EntityState.Detached;
list.Add(data);
}
}
return(list);
}
