public static bool AddCalibrationRow(CalibrationData row) { using (RIT_QAEntities1 db = new RIT_QAEntities1()) { Device dev = db.Devices.Find(row.Barcode); if (dev == null) { dev = new Device(); dev.Barcode = row.Barcode; dev.MAC = row.MAC_ADDRESS; dev.Date = DateTime.Now; db.Devices.Add(dev); } else { dev.MAC = row.MAC_ADDRESS; if (dev.Date == null) { dev.Date = DateTime.Now; } } SaveDbChenges(db); db.CalibrationDatas.Add(row); return(SaveDbChenges(db)); } }
static public User GetUserByID(int id) { User user; using (RIT_QAEntities1 db = new RIT_QAEntities1()) { user = db.Users.Find(id); } return(user); }
static public Device GetDeviceBySerialNumber(string serialNo) { Device dev; using (RIT_QAEntities1 db = new RIT_QAEntities1()) { dev = db.Devices.Find(serialNo); } return(dev); }
static bool SaveDbChenges(RIT_QAEntities1 db) { try { db.SaveChanges(); Logger.Info("Save chenges success"); return(true); } catch (Exception ex) { Logger.Error("Save chenges failed" + " " + ex.StackTrace.ToString() + (ex.InnerException != null ? ex.InnerException.ToString():"")); return(false); } }
public static int GetFirstUserID() { using (RIT_QAEntities1 db = new RIT_QAEntities1()) { User user = db.Users.FirstOrDefault(); if (user == null) { user = new User(); user.Name = "david"; user.Password = "******"; db.Users.Add(user); //SaveDbChenges(db); } return(user.Id); } }