protected void btnAlta_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtNombre.Text) && !string.IsNullOrWhiteSpace(txtValor.Text))
{
BE.Concepto conc = new BE.Concepto();
conc.Nombre = txtNombre.Text;
conc.Valor = float.Parse(txtValor.Text);
conc.TConcepto = ListaT[dropdownConcepto.SelectedIndex];
conc.VConcepto = ListaV[dropdownValor.SelectedIndex];
int fa = GestorConcepto.AgregarConcepto(conc);
if (fa != -1)
{
lblSuccess.Text = "El concepto fue agregado!";
lblSuccess.CssClass = "aler alert-success";
lblSuccess.Visible = true;
}
else
{
lblSuccess.Text = "Hubo un problema al guardar";
lblSuccess.CssClass = "aler alert-danger";
lblSuccess.Visible = true;
}
}
else
{
lblSuccess.Text = "Complete los campos!";
lblSuccess.CssClass = "aler alert-danger";
lblSuccess.Visible = true;
}
}
protected void btnModificar_Click(object sender, EventArgs e)
{
BE.Concepto c = new BE.Concepto();
c = ListaConc[dropdownConc.SelectedIndex];
if (c.ID != 5)
{
txtNombre.Visible = true;
txtValor.Visible = true;
dropdownConc.Visible = true;
dropdownConcepto.Visible = true;
dropdownValor.Visible = true;
btnAlta.Visible = true;
btnModificar.Visible = false;
btnBaja.Visible = false;
dropdownConc.Enabled = false;
BE.Concepto conce = ListaConc[dropdownConc.SelectedIndex];
txtValor.Text = conce.Valor.ToString();
txtNombre.Text = conce.Nombre;
dropdownConcepto.SelectedValue = conce.TConcepto.Tipo;
dropdownValor.SelectedValue = conce.VConcepto.TipoValor;
}
else
{
lblSuccess.Text = "No se puede modificar el Sueldo!";
lblSuccess.CssClass = "alert alert-danger";
lblSuccess.Visible = true;
}
}
protected void btnBaja_Click(object sender, EventArgs e)
{
BE.Concepto c = new BE.Concepto();
c = ListaConc[dropdownConc.SelectedIndex];
if (c.ID != 5)
{
int fa = GestorConcepto.BajaConcepto(c);
if (fa != -1)
{
lblSuccess.Text = "Concepto dado de baja!";
lblSuccess.CssClass = "alert alert-success";
lblSuccess.Visible = true;
ListaConc = GestorConcepto.ListarConceptos();
Session["ListaConceptos"] = ListaConc;
Enlazar();
}
else
{
lblSuccess.Text = "Ocurrio un error!";
lblSuccess.CssClass = "alert alert-danger";
lblSuccess.Visible = true;
}
}
else
{
lblSuccess.Text = "No se puede borrar el Sueldo!";
lblSuccess.CssClass = "alert alert-danger";
lblSuccess.Visible = true;
}
}
public List <BE.Concepto> ListarConceptos()
{
List <BE.Concepto> ListaConcepto = new List <BE.Concepto>();
SqlParameter[] parametros = new SqlParameter[1];
parametros[0] = acc.ArmarParametro("tabla", "Concepto", SqlDbType.VarChar);
acc.AbrirConexion();
DataTable tabla = acc.Leer("ListarEntidad", parametros);
acc.CerrarConexion();
GC.Collect();
foreach (DataRow linea in tabla.Rows)
{
if ((int)linea["Borrado"] == 0)
{
BE.Concepto conc = new BE.Concepto();
conc.ID = (int)linea["ID"];
conc.Nombre = (string)linea["Nombre"];
conc.Valor = float.Parse(linea["Valor"].ToString());
conc.TConcepto = MpTConcepto.ListarConceptos((int)linea["ID_Tipo"]);
conc.VConcepto = MpVConcepto.ListarConceptos((int)linea["ID_Valor"]);
ListaConcepto.Add(conc);
}
}
return(ListaConcepto);
}
protected void btnAlta_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtNombre.Text) && !string.IsNullOrWhiteSpace(txtValor.Text))
{
ListaV = (List <BE.ValorConcepto>)Session["ListaV"];
ListaT = (List <BE.TipoConcepto>)Session["ListaT"];
BE.Concepto conc = new BE.Concepto();
conc.ID = ListaConc[dropdownConc.SelectedIndex].ID;
conc.Nombre = txtNombre.Text;
conc.Valor = float.Parse(txtValor.Text);
conc.TConcepto = ListaT[dropdownConcepto.SelectedIndex];
conc.VConcepto = ListaV[dropdownValor.SelectedIndex];
int fa = GestorConcepto.ModificarConcepto(conc);
if (fa == -1)
{
lblSuccess.Text = "Ocurrio un error en la Base de Datos";
lblSuccess.CssClass = "alert alert-danger";
lblSuccess.Visible = true;
}
else
{
lblSuccess.Text = "Empleado guardado!!";
lblSuccess.CssClass = "alert alert-success";
lblSuccess.Visible = true;
btnAlta.Visible = false;
dropdownConcepto.Visible = false;
dropdownValor.Visible = false;
txtNombre.Visible = false;
txtValor.Visible = false;
btnModificar.Visible = true;
btnBaja.Visible = true;
dropdownConc.Enabled = true;
ListaConc = GestorConcepto.ListarConceptos();
Session["ListaConceptos"] = ListaConc;
Enlazar();
}
}
else
{
lblSuccess.Text = "Complete los datos!!";
lblSuccess.CssClass = "alert alert-success";
lblSuccess.Visible = true;
}
}
public int BajaConcepto(BE.Concepto conc)
{
int fa = 0;
acc.AbrirConexion();
SqlParameter[] parametros = new SqlParameter[1];
parametros[0] = acc.ArmarParametro("ID", conc.ID, System.Data.SqlDbType.Int);
fa = acc.Escribir("Concepto_Baja", parametros);
acc.CerrarConexion();
GC.Collect();
return(fa);
}
public int ModificarConcepto(BE.Concepto conc)
{
int fa = 0;
acc.AbrirConexion();
SqlParameter[] parametros = new SqlParameter[5];
parametros[0] = acc.ArmarParametro("IDTipo", conc.TConcepto.ID, System.Data.SqlDbType.Int);
parametros[1] = acc.ArmarParametro("Valor", conc.Valor, System.Data.SqlDbType.Float);
parametros[2] = acc.ArmarParametro("IDValor", conc.VConcepto.ID, System.Data.SqlDbType.Int);
parametros[3] = acc.ArmarParametro("Nombre", conc.Nombre, System.Data.SqlDbType.VarChar);
parametros[4] = acc.ArmarParametro("id", conc.ID, System.Data.SqlDbType.Int);
fa = acc.Escribir("Concepto_Modificar", parametros);
acc.CerrarConexion();
GC.Collect();
return(fa);
}
public int BajaConcepto(BE.Concepto conc)
{
int fa = MpCon.BajaConcepto(conc);
return(fa);
}
public int ModificarConcepto(BE.Concepto conc)
{
int fa = MpCon.ModificarConcepto(conc);
return(fa);
}
public int AgregarConcepto(BE.Concepto conc)
{
int fa = MpCon.AgregarConcepto(conc);
return(fa);
}
