Example #1
0
 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>());
     }
 }
Example #2
0
 public List <DeviceConfig> GetDeviceConfigs()
 {
     try
     {
         using (var db = BatteryDBContext.GetConnect())
         {
             return(db.DeviceConfig.ToList());
         }
     }
     catch (Exception ex)
     {
         return(new List <DeviceConfig>());
     }
 }
Example #3
0
 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>());
     }
 }
Example #4
0
 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);
     }
 }
Example #5
0
 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);
     }
 }
Example #6
0
 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);
     }
 }
Example #7
0
 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);
     }
 }
Example #8
0
 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);
     }
 }
Example #9
0
 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);
     }
 }
Example #10
0
 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);
     }
 }