public TEntity Get(int id)
{
using (var Context = new DevStoreDataContexts())
{
return(Context.Set <TEntity>().Find(id));
}
}
public IEnumerable <TEntity> Get()
{
using (var Context = new DevStoreDataContexts())
{
return(Context.Set <TEntity>().ToList());
}
}
public void Update(TEntity obj)
{
using (var Context = new DevStoreDataContexts())
{
Context.Entry(obj).State = EntityState.Modified;
Context.SaveChanges();
}
}
public void Delete(TEntity obj)
{
using (var Context = new DevStoreDataContexts())
{
Context.Set <TEntity>().Remove(obj);
Context.SaveChanges();
}
}
public void Add(TEntity obj)
{
using (var Context = new DevStoreDataContexts())
{
Context.Set <TEntity>().Add(obj);
Context.SaveChanges();
}
}
public void Delete(int id)
{
using (var Context = new DevStoreDataContexts())
{
var obj = Context.Set <TEntity>().Find(id);
Context.Set <TEntity>().Remove(obj);
Context.SaveChanges();
}
}
public List <Message> GetRecentMessages()
{
using (var db = new DevStoreDataContexts())
{
return(db.Message.Include("User")
.OrderByDescending(a => a.CreateDate)
.Take(50).ToList()
.OrderBy(a => a.CreateDate)
.ToList());
}
}
public ResponseObject NewMessageFromUser(string text, int id)
{
using (var db = new DevStoreDataContexts())
{
try
{
var message = new Message(text, id);
db.Message.Add(message);
db.SaveChanges();
return(new ResponseObject(true, "Message inserida com sucesso!", message));
}
catch (Exception)
{
return(new ResponseObject(false, "Erro ao tentar salvar Message!"));
}
}
}
public ResponseObject RegisterNewUser(string name)
{
using (var db = new DevStoreDataContexts())
{
try
{
var user = new DevStore.Domain.User(name);
db.User.Add(user);
db.SaveChanges();
return(new ResponseObject(true, "Usuário inserido com sucesso!", user));
}
catch (Exception)
{
return(new ResponseObject(false, "Erro ao tentar salvar usuário!"));
}
}
}
public ProductRepository()
{
_devStoreDataContexts = new DevStoreDataContexts();
}
public Service1()
{
db = new DevStoreDataContexts();
}
