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