private void btnGurdar_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("¿Estás seguro que quiere agregar esta acta de compromiso al sistema?", "",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
else
{
ac = new ActaComprobanteTO();
ac.NumAC = txtAC.Text;
ac.RDNum = txtRD.Text;
ac.Monto = Convert.ToDecimal(txtMonto.Text);
ac.Motivo = txtMotivo.Text;
ac.TipoGasto = cmbTipoGasto.Text;
ac.idPersonal = (int)cmbPersonal.SelectedValue;
_boChala.Insertar(ac);
LeerDatos();
}
}
catch (Exception ex)
{
MessageBox.Show("ERROR:" + ex.Message);
}
}
public void InsertarActaComprobante(ActaComprobanteTO act)
{
SqlConnection cn = null;
try
{
sSQL = "";
sSQL = " insert into ActaDeCompromiso values ('" + act.NumAC + "','" + act.RDNum + "',TRY_CONVERT(DATE,'20/09/2020',103),'";
sSQL = sSQL + act.TipoGasto + "'," + act.Monto.ToString() + ",'" + act.Motivo + "'," + act.NumDias.ToString() + ", TRY_CONVERT(DATE,'20/09/2020',103),TRY_CONVERT(DATE,'20/11/2020',103),TRY_CONVERT(DATE,'20/09/2020',103)," + act.idPersonal.ToString() + ")";
cn = con.getConexion();
cn.Open();
//conexion.Open();
comando = new SqlCommand(sSQL, cn);
comando.CommandType = CommandType.Text;
comando.ExecuteNonQuery();
Console.WriteLine("Exito en la Operacion");
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn != null)
{
cn.Close();
}
cn.Dispose();
sSQL = "";
con = null;
}
}
public void Insertar(ActaComprobanteTO comp)
{
try
{
_doChala.InsertarActaComprobante(comp);
}
catch (Exception ex)
{
throw ex;
}
}
