// method for getting venta
public static pBaseVentaFacturacion getVenta(string ID)
{
pBaseVentaFacturacion pBase = new pBaseVentaFacturacion();
using (SqlConnection con = DBcomun.getConnection())
{
SqlCommand comand = new SqlCommand(string.Format("SELECT * FROM Venta WHERE ID = '{0}'", ID), con);
SqlDataReader re = comand.ExecuteReader();
while (re.Read())
{
pBase.ID = re["ID"].ToString();
pBase.vendedorID = re["VendedorID"].ToString();
pBase.compradorID = re["CompradorID"].ToString();
pBase.Descripcion = re["Descripcion"].ToString();
pBase.MontoVenta = Convert.ToDouble(re["MontoVenta"]).ToString("f2");
pBase.Honorarios = Convert.ToDouble(re["Honorarios"]).ToString("f2");
pBase.Abono = Convert.ToDouble(re["Abono"]).ToString("f2");
pBase.servicioID = re["serviceID"].ToString();
}
con.Close();
}
return(pBase);
}
// method for getting venta
public static pBaseVentaFacturacion getVenta(string ID)
{
pBaseVentaFacturacion pBase = new pBaseVentaFacturacion();
using(SqlConnection con = DBcomun.getConnection())
{
SqlCommand comand = new SqlCommand(string.Format("SELECT * FROM Venta WHERE ID = '{0}'", ID), con);
SqlDataReader re = comand.ExecuteReader();
while (re.Read())
{
pBase.ID = re["ID"].ToString();
pBase.vendedorID = re["VendedorID"].ToString();
pBase.compradorID = re["CompradorID"].ToString();
pBase.Descripcion = re["Descripcion"].ToString();
pBase.MontoVenta = Convert.ToDouble(re["MontoVenta"]).ToString("f2");
pBase.Honorarios = Convert.ToDouble(re["Honorarios"]).ToString("f2");
pBase.Abono = Convert.ToDouble(re["Abono"]).ToString("f2");
pBase.servicioID = re["serviceID"].ToString();
}
con.Close();
}
return pBase;
}
