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