private void CargaDatos() { try { DataSet ds = new DataSet(); GestionMetasBE GestionMetasBE = new GestionMetasBE() { OPCION = 1, USUARIO = General.General.GetUsuario, Annio = txtAnnio.Text, Mes = cboMes.SelectedValue.ToString() }; ds = new GestionMetasBL().ProcesarGestionMetas(GestionMetasBE); dgvGestionMetas.DataSource = ds.Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataSet ProcesarGestionMetas(GestionMetasBE BE) { DataSet dsResult; try { cmd = db.GetStoredProcCommand("GestionMetas_Mnt"); db.AddInParameter(cmd, "OPCION", DbType.Int32, BE.OPCION); db.AddInParameter(cmd, "USUARIO", DbType.String, BE.USUARIO); db.AddInParameter(cmd, "Annio", DbType.String, BE.Annio); db.AddInParameter(cmd, "Mes", DbType.String, BE.Mes); db.AddInParameter(cmd, "GestorId", DbType.String, BE.GestorId); db.AddInParameter(cmd, "Monto", DbType.Decimal, BE.Monto); dsResult = db.ExecuteDataSet(cmd); } catch (Exception ex) { throw new Exception(ex.Message); } return(dsResult); }
private void btnProcesar_Click(object sender, EventArgs e) { try { GestionMetasBE oEntity = new GestionMetasBE(); foreach (DataGridViewRow row in dgvGestionMetas.Rows) { oEntity.OPCION = 2; oEntity.USUARIO = General.General.GetUsuario; oEntity.Annio = row.Cells["Annio"].Value.ToString(); oEntity.Mes = row.Cells["Mes"].Value.ToString(); oEntity.GestorId = row.Cells["GestorId"].Value.ToString(); oEntity.Monto = string.IsNullOrEmpty(row.Cells["Monto"].Value.ToString())? 0 : Convert.ToDecimal(row.Cells["Monto"].Value); new GestionMetasBL().ProcesarGestionMetas(oEntity); } MessageBox.Show("Se proceso correctamente", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DataSet ProcesarGestionMetas(GestionMetasBE BE) { return(GestionMetasDA.ProcesarGestionMetas(BE)); }