public List <UserInfo> GetUsers()
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
return(db.UserInfo.Where(s => s.UserName != "admin").ToList());
}
}
catch (Exception ex)
{
return(new List <UserInfo>());
}
}
public List <DeviceConfig> GetDeviceConfigs()
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
return(db.DeviceConfig.ToList());
}
}
catch (Exception ex)
{
return(new List <DeviceConfig>());
}
}
public List <Dictonary> QueryDictionary(string type)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
return(db.Dictonary.Where(s => s.Type == type).ToList());
}
}
catch (Exception ex)
{
return(new List <Dictonary>());
}
}
public UserInfo Login(string name, string password)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
var item = db.UserInfo.FirstOrDefault(s => s.UserName == name && s.Password == password);
return(item);
}
}
catch (Exception ex)
{
return(null);
}
}
public bool CreateUser(UserInfo user)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
db.UserInfo.Add(user);
int ret = db.SaveChanges();
return(ret >= 1);
}
}
catch
{
return(false);
}
}
public bool Create(DeviceConfig entity)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
db.DeviceConfig.Add(entity);
int ret = db.SaveChanges();
return(ret >= 1);
}
}
catch
{
return(false);
}
}
public bool DeleteUser(UserInfo user)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
var entry = db.Entry <UserInfo>(user);
entry.State = System.Data.Entity.EntityState.Deleted;
var ret = db.SaveChanges();
return(ret >= 1);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdatePassWord(int userId, string password)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
var user = db.UserInfo.First((s) => s.UserID == userId);
user.Password = password;
var ret = db.SaveChanges();
return(ret >= 0);
}
}
catch
{
return(false);
}
}
public bool Delete(DeviceConfig entity)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
var entry = db.Entry <DeviceConfig>(entity);
entry.State = System.Data.Entity.EntityState.Deleted;
var ret = db.SaveChanges();
return(ret >= 1);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool Login(string name, string password)
{
try
{
using (var db = BatteryDBContext.GetConnect())
{
var item = db.UserInfo.FirstOrDefault(s => s.UserName == name && s.Password == password);
if (item != null)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
