public Boolean GuardarBoletaLN(EntBoleta entBoleta)
{
try
{
return(dataBoleta.GuardarBoleta(entBoleta));
}
catch (Exception)
{
throw;
}
}
protected void btnBoleta_Click(object sender, EventArgs e)
{
boleta = new EntBoleta();
try
{
boleta.id_boleta = Convert.ToInt16(codBoleta.Text.ToString());
boleta.desc_boleta = codigoBoleta.Text.ToString();
List <EntDetalle> listaDetalle = new List <EntDetalle>();
boleta.listDetalle = listaDetalle;
Session["s_Boleta"] = boleta; // que es esto de session
Response.Redirect("~/Default3.aspx");
}
catch (Exception ex)
{
// Label1.Text = "Error..." + ex.Message.ToString();
}
}
// SqlCommand comandoSQL;
#region Guardar Boleta
public static Boolean GuardarBoleta(EntBoleta entBoleta)
{
//SqlConnection conectar = new SqlConnection(ADConexion.ConexionR2()); conectar.Open();
SqlCommand comandoSQL = ClsConexion.GET_CONEXION().CreateCommand();
// comando SqlCommand comandoSQL = new SqlCommand();
comandoSQL.CommandText = "paInsertarBoletaDetalle";
comandoSQL.CommandType = System.Data.CommandType.StoredProcedure;
// comandoSQL.Connection = conectar;
try { comandoSQL.Parameters.Clear();
DataTable dtTipoDetalle = new DataTable();
dtTipoDetalle.Columns.Add("id_boleta", typeof(int));
dtTipoDetalle.Columns.Add("num_linea", typeof(int));
dtTipoDetalle.Columns.Add("detalle", typeof(string));
foreach (EntDetalle objDetalle in entBoleta.listDetalle)
{
DataRow dr = dtTipoDetalle.NewRow();
dr["id_boleta"] = objDetalle.id_boleta;
dr["num_linea"] = objDetalle.numLinea;
dr["detalle"] = objDetalle.detalle;
dtTipoDetalle.Rows.Add(dr);
}
comandoSQL.Parameters.Add(new SqlParameter("@listatipoDetalle", dtTipoDetalle));
comandoSQL.Parameters.Add(new SqlParameter("@id_boleta", entBoleta.id_boleta));
comandoSQL.Parameters.Add(new SqlParameter("@descri_boleta", entBoleta.desc_boleta));
comandoSQL.ExecuteNonQuery(); return(true); }
catch (Exception ex) { throw ex; }
finally
{
if (comandoSQL.Connection.State == System.Data.ConnectionState.Open)
{
comandoSQL.Connection.Close();
}
comandoSQL.Dispose();
}
}
