internal List <Financeiro.ViewModels.DespesaViewModel> PegarTodasDespesasPartialView() { List <Financeiro.ViewModels.DespesaViewModel> despesas = new List <Financeiro.ViewModels.DespesaViewModel>(); using (SqlConnection connection = new SqlConnection(StringConnection)) { try { connection.Open(); var command = new SqlCommand(SelectTodasDespesasViewModel, connection); var dataReader = command.ExecuteReader(); while (dataReader.Read()) { Financeiro.ViewModels.DespesaViewModel Despesa = new Financeiro.ViewModels.DespesaViewModel(); Despesa.Id = Convert.ToInt32(dataReader["DespesaId"]); Despesa.EstaPago = dataReader["EstaPago"].ToString() == "TRUE" ? true : false; Despesa.Vencimento = DateTime.Parse(dataReader["Vencimento"].ToString()); Despesa.TipoDespesa = dataReader["TipoDespesaNome"].ToString(); Despesa.Valor = Convert.ToDouble(dataReader["Valor"]); despesas.Add(Despesa); } dataReader.Close(); command.Dispose(); connection.Close(); } catch (Exception ex) { } } return(despesas); }
public ActionResult UpdateDespesa(Financeiro.ViewModels.DespesaViewModel despesa, string myHiddenInput, string Id) { Financeiro.Processo.ProcessoFinancas processo = new Processo.ProcessoFinancas(); processo.AtualizarDespesa(despesa); return(View("Despesas")); }
internal DespesaViewModel PegarDespesaViewModelPorId(int id) { List <DespesaViewModel> despesas = new List <DespesaViewModel>(); using (SqlConnection connection = new SqlConnection(StringConnection)) { try { // private string InsertConta = "INSERT INTO Contas (Nome,Saldo,CreateTime,CreateBy,Obsoleto) VALUES(@Nome,@Saldo,@CreateTime,@CreateBy,@Obsoleto)"; connection.Open(); using (SqlCommand cmd = new SqlCommand(SelectDespesaViewModelPorId, connection)) { cmd.Parameters.Add(new SqlParameter("@Id", id)); // cn.Open(); var dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { Conta conta = new Conta(); Financeiro.ViewModels.DespesaViewModel Despesa = new Financeiro.ViewModels.DespesaViewModel(); Despesa.Id = Convert.ToInt32(dataReader["Id"]); Despesa.EstaPago = dataReader["EstaPago"].ToString() == "TRUE" ? true : false; Despesa.Vencimento = DateTime.Parse(dataReader["Vencimento"].ToString()); Despesa.TipoDespesa = dataReader["TipoDespesaId"].ToString(); Despesa.Descricao = dataReader["Descricao"].ToString(); Despesa.Valor = Convert.ToDouble(dataReader["Valor"]); Despesa.Conta = dataReader["ContaId"].ToString(); despesas.Add(Despesa); } dataReader.Close(); cmd.Dispose(); connection.Close(); } } catch (Exception ex) { } } return(despesas.FirstOrDefault()); }