/// <summary>
/// fas query na tabela de filmes
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
static public List <Movie> GetMovies(Movie u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var query = db.Movies.ToList().AsQueryable();
if (u.Id != 0)
{
query = query.Where(r => r.Id == u.Id).ToList().AsQueryable();
}
if (u.Name != null)
{
query = query.Where(r => r.Name.Contains(u.Name)).ToList().AsQueryable();
}
dbContextTransaction.Commit();
return(query.ToList());
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(null);
}
}
}
}
static public bool CreateMovie(Movie u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
u.CreationDate = DateTime.Now;
u.Active = true;
u.Del = false;
db.Movies.Add(u);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(false);
}
}
}
}
/// <summary>
/// faz query na tabela de usuários
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
static public List <User> GetUser(User u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var query = db.Users.ToList().AsQueryable();
if (u.Id != 0)
{
query = query.Where(r => r.Id == u.Id).ToList().AsQueryable();
}
if (u.Name != null)
{
query = query.Where(r => r.Name.Contains(u.Name)).ToList().AsQueryable();
}
if (u.Email != null)
{
query = query.Where(r => r.Email.Contains(u.Email)).ToList().AsQueryable();
}
var guidCompare = new Guid("00000000-0000-0000-0000-000000000000");
if (u.UserGuid != guidCompare)
{
query = query.Where(r => r.UserGuid == u.UserGuid).ToList().AsQueryable();
}
if (u.Password != null)
{
query = query.Where(r => r.Password.Contains(u.Password)).ToList().AsQueryable();
}
dbContextTransaction.Commit();
return(query.ToList());
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(null);
}
}
}
}
static public List <LocateRegister> GetLocateRegister(LocateRegister u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
dbContextTransaction.Commit();
return(db.LocateRegisters.ToList());
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(null);
}
}
}
}
static public bool CreateRegister(LocateRegister u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
db.LocateRegisters.Add(u);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(false);
}
}
}
}
static public int CreateLocation(Location u)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
u.LocationDate = DateTime.Now;
db.Locations.Add(u);
db.SaveChanges();
dbContextTransaction.Commit();
return(u.Id);
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(0);
}
}
}
}
static public bool DeleteMovie(int Id)
{
using (Context db = new Context(ConnectionString.BaseApiGlobal("CatherineDB")))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Movie u = db.Movies.Find(Id);
db.Entry(u).State = EntityState.Deleted;
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception err)
{
//escreve log
Common.Log.Write("UserPersistence CreateUser", err.Message);
dbContextTransaction.Rollback();
return(false);
}
}
}
}
