public List <ClienteTag> getclientetaglist(Int32 id_cliente, int id_familia, string tipo_operacion)
{
try
{
using (SqlConnection sqlConn = new SqlConnection(this.strConn))
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(strConn, sqlConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_get_clientetaglist";
cmd.Parameters.AddWithValue("@id_cliente", id_cliente);
cmd.Parameters.AddWithValue("@id_familia", id_familia);
cmd.Parameters.AddWithValue("@tipo_operacion", tipo_operacion);
SqlDataReader reader = cmd.ExecuteReader();
List <ClienteTag> lClientetag = new List <ClienteTag>();
while (reader.Read())
{
ClienteTag mCliente = new ClienteTag();
mCliente.Id_codigo = Convert.ToInt16(reader["id_tipogasto"].ToString());
mCliente.Montotag = Convert.ToString(reader["valor"]);
mCliente.Opcional = Convert.ToString(reader["opcional"]);
mCliente.Nombre = reader["Descripcion"].ToString();
lClientetag.Add(mCliente);
}
return(lClientetag);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ClienteTag getclientetag(Int32 id_cliente, int id_familia)
{
try
{
using (SqlConnection sqlConn = new SqlConnection(this.strConn))
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(strConn, sqlConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_get_clientetag";
cmd.Parameters.AddWithValue("@id_cliente", id_cliente);
cmd.Parameters.AddWithValue("@id_familia", id_familia);
SqlDataReader reader = cmd.ExecuteReader();
ClienteTag mclientetag = new ClienteTag();
if (reader.Read())
{
mclientetag.Monto = reader["Monto_cliente"].ToString();
mclientetag.Montotag = reader["Monto_agp"].ToString();
mclientetag.Id_familia = Convert.ToInt16(reader["id_familia"].ToString());
return(mclientetag);
}
else
{
mclientetag.Monto = "0";
}
return(mclientetag);
}
}
catch (Exception ex)
{
throw ex;
}
}