public static int GetUserId(string token) { using (CycloidContext context = new CycloidContext()) { var tkn = context.Set <Models.Token>().Where(x => x.Tkn == token).FirstOrDefault(); return(tkn.UserId); } }
public static void Delete(string token) { using (CycloidContext context = new CycloidContext()) { var tkn = context.Set <Models.Token>().Where(x => x.Tkn == token).FirstOrDefault(); context.Entry(tkn).State = System.Data.EntityState.Deleted; } }
public static void Update(Models.Device device) { using (CycloidContext context = new CycloidContext()) { context.Entry(device).State = EntityState.Modified; context.SaveChanges(); } }
public static void SetToken(Models.Token token) { using (CycloidContext context = new CycloidContext()) { context.Token.Add(token); context.SaveChanges(); } }
public static void UpdateUser(Models.User user) { using (CycloidContext context = new CycloidContext()) { context.Entry(user).State = EntityState.Modified; context.SaveChanges(); } }
public static void Add(Models.Device device) { using (CycloidContext context = new CycloidContext()) { context.Device.Add(device); context.SaveChanges(); } }
public static Models.User GetById(int id) { using (CycloidContext context = new CycloidContext()) { var user = context.Set <Models.User>().Find(id); return(user); } }
public static void Registration(Models.User user) { using (CycloidContext context = new CycloidContext()) { context.User.Add(user); context.SaveChanges(); } }
public static void Add(Models.Room room) { using (CycloidContext context = new CycloidContext()) { context.Room.Add(room); context.SaveChanges(); } }
public static Models.Device GetById(int id) { Models.Device room = new Models.Device(); using (CycloidContext context = new CycloidContext()) { room = context.Set <Models.Device>().Find(id); } return(room); }
public static void Delete(int id) { var device = GetById(id); using (CycloidContext context = new CycloidContext()) { context.Entry(device).State = EntityState.Deleted; context.SaveChanges(); } }
public static List <Models.Device> GetByRoom(int id) { List <Models.Device> res = new List <Models.Device>(); using (CycloidContext context = new CycloidContext()) { res = context.Set <Models.Device>().Where(x => x.Room.Id == id).ToList <Models.Device>(); } return(res); }
public static Models.User Login(string login, string pass) { var res = new Models.User(); using (CycloidContext context = new CycloidContext()) { res = context.Set <Models.User>().Where(x => x.Login == login && x.Password == pass).FirstOrDefault(); } return(res); }
public static List <Models.Room> GetByUser(int id) { List <Models.Room> res = new List <Models.Room>(); using (CycloidContext context = new CycloidContext()) { res = context.Set <Models.Room>().Where(x => x.User.Id == id).ToList <Models.Room>(); } return(res); }
public static void Delete(int id) { var room = GetById(id); using (CycloidContext context = new CycloidContext()) { var devices = DataAccess.Device.GetByRoom(id); foreach (var device in devices) { context.Entry(device).State = EntityState.Deleted; } context.Entry(room).State = EntityState.Deleted; context.SaveChanges(); } }