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