public static void adicionar(TipoGasto categoria) { SGFEntities db = new SGFEntities(); db.TipoGasto.Add(categoria); db.SaveChanges(); }
public static Usuario id(int id) { SGFEntities db = new SGFEntities(); Usuario user = db.Usuario.SingleOrDefault(x => x.id == id); return(user); }
public static void cadastrar(Usuario user) { SGFEntities db = new SGFEntities(); db.Usuario.Add(user); db.SaveChanges(); }
public static void cadastrar(Gasto gasto) { SGFEntities db = new SGFEntities(); db.Gasto.Add(gasto); db.SaveChanges(); }
public static void adicionar(Item item) { SGFEntities db = new SGFEntities(); db.Item.Add(item); db.SaveChanges(); }
public static void atualizar(int id, String nome) { SGFEntities db = new SGFEntities(); TipoGasto cat = db.TipoGasto.SingleOrDefault(x => x.id == id); cat.nome = nome; db.SaveChanges(); }
public static void reduceSaldo(int id, double valor) { SGFEntities db = new SGFEntities(); Usuario currentUser = db.Usuario.First(x => x.id == id); currentUser.saldo -= valor; db.SaveChanges(); }
public static void senha(int id, String senha) { SGFEntities db = new SGFEntities(); Usuario currentUser = db.Usuario.First(x => x.id == id); currentUser.senha = senha; db.SaveChanges(); }
public static void atualizar(double novoValor, int id) { SGFEntities db = new SGFEntities(); Gasto gasto = db.Gasto.SingleOrDefault(x => x.id == id); gasto.valor = novoValor; db.SaveChanges(); }
public static void atualizar(int ano, int mes, double valor, int userId) { SGFEntities db = new SGFEntities(); Renda renda = db.Renda.SingleOrDefault(x => x.ano == ano && x.mes == mes && x.usuario_id == userId); renda.valor = valor; db.SaveChanges(); }
public static void delete(Item item) { SGFEntities db = new SGFEntities(); var itemDelete = db.Item.SingleOrDefault(x => x.id == item.id); db.Item.Remove(itemDelete); db.SaveChanges(); }
public static void saldo(int id, double saldo) { SGFEntities db = new SGFEntities(); Usuario currentUser = db.Usuario.First(x => x.id == id); currentUser.saldo = saldo; db.SaveChanges(); }
public static void atualizar(int id, double valor, String nome, int dia, int tipo) { SGFEntities db = new SGFEntities(); Item item = db.Item.SingleOrDefault(x => x.id == id); item.nome = nome; item.valor = valor; item.dia = dia; item.tipo = tipo; db.SaveChanges(); }
public static void delete(int id) { SGFEntities db = new SGFEntities(); var gasto = db.Gasto.SingleOrDefault(x => x.id == id); foreach (Item item in gasto.Item.ToList()) { var item1 = db.Item.SingleOrDefault(x => x.id == item.id); db.Item.Remove(item1); } db.Gasto.Remove(gasto); db.SaveChanges(); }
public static void ano(int ano, int userId) { List <Renda> rendas = new List <Renda>(); for (int i = 1; i <= 12; i++) { Renda renda = new Renda(); renda.ano = ano; renda.mes = i; renda.valor = 0; renda.usuario_id = userId; rendas.Add(renda); } SGFEntities db = new SGFEntities(); db.Renda.AddRange(rendas); db.SaveChanges(); }
public static void delete(TipoGasto categoria) { SGFEntities db = new SGFEntities(); var cat = db.TipoGasto.SingleOrDefault(x => x.id == categoria.id); foreach (Gasto gasto in cat.Gasto.ToList()) { foreach (Item item in gasto.Item.ToList()) { var item1 = db.Item.SingleOrDefault(x => x.id == item.id); db.Item.Remove(item1); } var gasto1 = db.Gasto.SingleOrDefault(x => x.id == gasto.id); db.Gasto.Remove(gasto1); } db.TipoGasto.Remove(cat); db.SaveChanges(); }
public static Usuario conferir(String email, String senha) { SGFEntities db = new SGFEntities(); try { Usuario user = db.Usuario.SingleOrDefault(x => x.email == email); if (user.senha == senha) { return(user); } else { throw new Exception(); } } catch (Exception e) { return(null); } }
public static TipoGasto id(int id) { SGFEntities db = new SGFEntities(); return(db.TipoGasto.SingleOrDefault(x => x.id == id)); }
public static Usuario email(String email) { SGFEntities db = new SGFEntities(); return(db.Usuario.SingleOrDefault(x => x.email == email)); }
public static List <Renda> ano(int ano, int id) { SGFEntities db = new SGFEntities(); return(db.Renda.SqlQuery("SELECT * FROM Renda WHERE ano = " + ano + "AND Usuario_id = " + id).ToList <Renda>()); }
public static Item pesquisar(int id) { SGFEntities db = new SGFEntities(); return(db.Item.SingleOrDefault(x => x.id == id)); }
public static List <TipoGasto> userId(int userId) { SGFEntities db = new SGFEntities(); return(db.TipoGasto.SqlQuery("SELECT * FROM TipoGasto WHERE Usuario_id = " + userId).ToList <TipoGasto>()); }
public static List <Usuario> nome(String nome) { SGFEntities db = new SGFEntities(); return(db.Usuario.SqlQuery("SELECT * FROM Usuario WHERE nome = '" + nome + "'").ToList <Usuario>()); }
public static Renda renda(int user_id, int mes, int ano) { SGFEntities db = new SGFEntities(); return(db.Renda.SingleOrDefault(x => x.usuario_id == user_id && x.mes == mes && x.ano == ano)); }
public static Gasto data(int ano, int mes, int catId) { SGFEntities db = new SGFEntities(); return(db.Gasto.SingleOrDefault(x => x.mes == mes && x.ano == ano && x.tipoGasto_id == catId)); }