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