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