public static bool Save(Produto obj) { obj.dataCriacao = DateTime.Now; obj.dataEdicao = DateTime.Now; try { if (obj.ID == 0) { using (var db = new WebPixContext()) { db.Produto.Add(obj); db.SaveChanges(); } return(true); } else { using (var db = new WebPixContext()) { db.Produto.Update(obj); db.SaveChanges(); return(true); } } } catch (Exception e) { return(false); } }
public static int Save(Propiedades obj) { obj.dataCriacao = DateTime.Now; obj.dataEdicao = DateTime.Now; try { if (obj.ID == 0) { using (var db = new WebPixContext()) { db.Propiedades.Add(obj); db.SaveChanges(); } return(obj.ID); } else { using (var db = new WebPixContext()) { db.Propiedades.Update(obj); db.SaveChanges(); return(obj.ID); } } } catch (Exception e) { return(0); } }
public static bool SaveDept(List <Estrutura> departamento, int idUsuario, int idPropiedade, int idCliente) { foreach (Estrutura obj in departamento) { obj.dataCriacao = DateTime.Now; obj.dataEdicao = DateTime.Now; try { var query = String.Format( @"insert into EstruturaXPropriedade values({0}, {1}, '{2}', '{3}', {4}, {5},{6})", obj.ID, idPropiedade, String.Format("{0:yyyy/MM/dd}", DateTime.Now), String.Format("{0:yyyy/MM/dd}", DateTime.Now), idUsuario, idUsuario, idCliente); using (var db = new WebPixContext()) { int noOfRowInserted = db.Database.ExecuteSqlCommand(query); } } catch (Exception e) { } } return(true); }
public static bool Save(UsuarioPermissao obj) { obj.DataCriacao = DateTime.Now; obj.DateAlteracao = DateTime.Now; try { if (obj.ID == 0) { using (var db = new WebPixContext()) { db.UsuarioPermissao.Add(obj); db.SaveChanges(); } return(true); } else { using (var db = new WebPixContext()) { db.UsuarioPermissao.Update(obj); db.SaveChanges(); return(true); } } } catch (Exception e) { return(false); } }
public static List <Produto> GetAll() { try { using (var db = new WebPixContext()) { return(db.Produto.ToList()); } } catch (Exception e) { //// return(new List <Produto>()); } }
public static List <UsuarioPermissao> GetAll() { try { using (var db = new WebPixContext()) { return(db.UsuarioPermissao.ToList()); } } catch (Exception e) { //// return(new List <UsuarioPermissao>()); } }
public async static Task <IEnumerable <Permissao> > GetByIdsAsync(IEnumerable <int> ids) { try { using (var db = new WebPixContext()) { var result = await db.Permissao.Where(p => ids.Contains(p.ID) && Convert.ToBoolean(p.VAdmin)).ToListAsync(); return(result); } } catch (Exception e) { return(new List <Permissao>()); } }
public static bool Remove(Produto obj) { try { using (var db = new WebPixContext()) { db.Produto.Remove(obj); db.SaveChanges(); return(true); } } catch (Exception e) { //// return(false); } }
public async static Task <IEnumerable <Permissao> > GetByIdsAndMotor(IEnumerable <int> permissoesIDs, int idMotorAux) { try { using (var db = new WebPixContext()) { var result = await db.Permissao.Where(p => permissoesIDs.Contains(p.ID) && p.IdAux.Equals(idMotorAux)).ToListAsync(); return(result); } } catch (Exception e) { return(new List <Permissao>()); } }
public static async Task <Permissao> CarregarPermissaoByUsuarioAsync(int idUsuario) { try { using (var db = new WebPixContext()) { var permissao = await db.Set <Permissao>().FromSql(@" select a.* from Permissao a inner join PermissaoXUsuario b on b.idUsuario = {0} where a.id = b.idPermissao", idUsuario).FirstOrDefaultAsync(); return(permissao); } } catch (Exception e) { return(new Permissao()); } }