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