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