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