private void Guardar(DateTime fecha, string detalle, string total)
{
using (GestorGasto Expense = new GestorGasto()) {
Expense.InsertarGasto(fecha, detalle, total);
MessageBox.Show("Save Successfull");
}
}
private void Modificar(int id_expense, DateTime fecha, string detalle, string total)
{
using (GestorGasto Expense = new GestorGasto())
{
Expense.ModificarGasto(id_expense, fecha, detalle, total);
MessageBox.Show("Save Successfull");
}
}
public void CargarDataGridView()
{
using (GestorGasto elGasto = new GestorGasto()) {
dgvExpenses.DataSource = elGasto.ListarGastos();
dgvExpenses.Columns["id_expense"].Visible = false;
dgvExpenses.Columns["date"].HeaderText = "Date";
dgvExpenses.Columns["details"].HeaderText = "Detail";
dgvExpenses.Columns["amount"].HeaderText = "Amount";
}
}
private void consultafecha(string f1, string f2)
{
string Fecha1 = "";
string Fecha2 = "";
string[] fechone;
string[] fechtwo;
f1 = f1.Replace(" ", "-");
f2 = f2.Replace(" ", "-");
fechone = f1.Split('-');
fechtwo = f2.Split('-');
foreach (string i in fechone)
{
Fecha1 = fechone[2] + "-" + fechone[1] + "-" + fechone[0];
}
foreach (string i in fechtwo)
{
Fecha2 = fechtwo[2] + "-" + fechtwo[1] + "-" + fechtwo[0];
}
using (GestorGasto Gasto = new GestorGasto())
{
DataTable dtRegistro = new DataTable();
DataSet dsRegistro = new DataSet();
dsRegistro = Gasto.GetexpenseByDate(Fecha1, Fecha2);
dtRegistro = dsRegistro.Tables[0];
dgvExpenses.DataSource = dtRegistro;
dgvExpenses.Columns["id_expense"].Visible = false;
dgvExpenses.Columns["date"].HeaderText = "Date";
dgvExpenses.Columns["details"].HeaderText = "Detail";
dgvExpenses.Columns["amount"].HeaderText = "Amount";
}
}
