public List <SGP_Entity.Moneda> Sel_Moneda(SGP_Entity.Moneda ent)
{
List <SGP_Entity.Moneda> lista = new List <SGP_Entity.Moneda>();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["cnx"].ConnectionString;
try
{
SqlCommand cmd = new SqlCommand();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Sp_Sel_Moneda";
//Inicio Parámetros
cmd.Parameters.Add("@de_moneda", SqlDbType.VarChar, 30).Value = ent.de_moneda;
cmd.Parameters.Add("@co_moneda", SqlDbType.Int).Value = ent.co_moneda;
cmd.Parameters.Add("@st_moneda", SqlDbType.Char, 1).Value = ent.st_moneda;
//Fin Parámetros
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
SGP_Entity.Moneda ar = new SGP_Entity.Moneda();
ar.co_moneda = Convert.ToInt32(dr["co_moneda"].ToString());
ar.de_moneda = dr["de_moneda"].ToString();
ar.sm_moneda = dr["sm_moneda"].ToString();
ar.st_moneda = dr["st_moneda"].ToString();
ar.tx_valor1 = (ar.st_moneda == "1" ? "SI" : "NO");
lista.Add(ar);
}
return(lista);
}
catch (Exception)
{
throw;
}
}
public int Upd_Moneda(SGP_Entity.Moneda ent)
{
int retorno = 0;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["cnx"].ConnectionString;
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Sp_Upd_Moneda";
//Inicio Parámetros
cmd.Parameters.Add("@co_moneda", SqlDbType.Int).Value = ent.co_moneda;
cmd.Parameters.Add("@de_moneda", SqlDbType.VarChar, 30).Value = ent.de_moneda;
cmd.Parameters.Add("@sm_moneda", SqlDbType.VarChar, 5).Value = ent.sm_moneda;
cmd.Parameters.Add("@ti_moneda", SqlDbType.Char, 1).Value = ent.ti_moneda;
cmd.Parameters.Add("@fg_moneda", SqlDbType.VarChar, 1).Value = ent.fg_moneda;
cmd.Parameters.Add("@st_moneda", SqlDbType.Char, 1).Value = ent.st_moneda;
cmd.Parameters.Add("@co_usuario_modificacion", SqlDbType.Char, 20).Value = ent.co_usuario_modificacion;
//Fin Parámetros
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(retorno);
}
catch (Exception)
{
throw;
}
}
public List <SGP_Entity.Moneda> Sel_ComboMoneda(SGP_Entity.Moneda ent)
{
List <SGP_Entity.Moneda> lista = new List <SGP_Entity.Moneda>();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["cnx"].ConnectionString;
try
{
SqlCommand cmd = new SqlCommand();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Sp_Sel_ComboMoneda";
//Inicio Parámetros
//Fin Parámetros
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
SGP_Entity.Moneda obj = new SGP_Entity.Moneda();
obj.codigo = Convert.ToInt32(dr["codigo"].ToString());
obj.descripcion = dr["descripcion"].ToString();
lista.Add(obj);
}
return(lista);
}
catch (Exception)
{
throw;
}
}
