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