public Caj_DenominacionBE ConsultarDenominacion(int in_idDenominacion)
{
try
{
objSqlConnection.Open();
Caj_DenominacionBE objDenominacion;
SqlCommand objSqlCommand = new SqlCommand("sp_sel_Caj_Denominacion_seleccionar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
objSqlCommand.Parameters.Add(new SqlParameter("@i_idDenominacion", in_idDenominacion));
SqlDataReader objSqlDateReader = objSqlCommand.ExecuteReader();
if (objSqlDateReader.Read())
{
objDenominacion = new Caj_DenominacionBE();
objDenominacion.in_idDenominacion = (int)objSqlDateReader["i_idDenominacion"];
objDenominacion.bl_ver = (bool)objSqlDateReader["b_ver"];
objDenominacion.dt_fchRegistro = (DateTime)(objSqlDateReader["dt_fchRegistro"]);
objDenominacion.st_dscpDenominacion = (string)objSqlDateReader["vc_dscpDenominacion"];
return(objDenominacion);
}
objSqlConnection.Close();
return(null);
}
catch (Exception e)
{
objSqlConnection.Close();
return(null);
}
}
public List <Caj_DenominacionBE> ListarDenominacion(int _case, string filtro)
{
try
{
SqlConnection objSqlConnection = Conexion.GetConexion();
objSqlConnection.Open();
List <Caj_DenominacionBE> objListDenominacion = new List <Caj_DenominacionBE>();
Caj_DenominacionBE objDenominacion; //sp_list_Caj_Denominacion_listar
SqlCommand objSqlCommand = new SqlCommand("sp_list_Caj_Denominacion_listar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
objSqlCommand.Parameters.Add(new SqlParameter("@case", _case));
objSqlCommand.Parameters.Add(new SqlParameter("@filtro", _case == -1 ? "''" :filtro));
SqlDataReader objSqlDataReader = objSqlCommand.ExecuteReader();
while (objSqlDataReader.Read())
{
objDenominacion = new Caj_DenominacionBE();
objDenominacion.in_idDenominacion = (int)objSqlDataReader["i_idDenominacion"];
objDenominacion.bl_ver = (bool)objSqlDataReader["b_ver"];
objDenominacion.dt_fchRegistro = (DateTime)objSqlDataReader["dt_fchRegistro"];
objDenominacion.st_dscpDenominacion = (string)objSqlDataReader["vc_dscpDenominacion"];
objListDenominacion.Add(objDenominacion);
}
objSqlDataReader.Close();
objSqlConnection.Close();
return(objListDenominacion);
}
catch (Exception e)
{
return(null);
}
}
public Boolean ModificarDenominacion(Caj_DenominacionBE objDenominacion)
{
try
{
objSqlConnection.Open();
SqlCommand objSqlCommand = new SqlCommand("sp_upd_Caj_Denominacion_actualizar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
// objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.Parameters.Add(new SqlParameter("@i_idDenominacion", objDenominacion.in_idDenominacion));
objSqlCommand.Parameters.Add(new SqlParameter("@vc_dscpDenominacion", objDenominacion.st_dscpDenominacion));
objSqlCommand.ExecuteNonQuery();
//objSqlTransaction.Commit();
objSqlConnection.Close();
return(true);
}
catch (Exception e)
{
objSqlConnection.Close();
return(false);
}
}
public Boolean QuitarDenominacion(Caj_DenominacionBE objDenominacion)
{
try
{
objSqlConnection.Open();
SqlCommand objSqlCommand = new SqlCommand("sp_del_Caj_Denominacion_eliminar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
// objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.Parameters.Add(new SqlParameter("@i_idDenominacion", objDenominacion.in_idDenominacion));
objSqlCommand.Parameters.Add(new SqlParameter("@b_ver", objDenominacion.bl_ver));
objSqlCommand.ExecuteNonQuery();
//objSqlTransaction.Commit();
objSqlConnection.Close();
return(true);
}
catch (Exception e)
{
objSqlConnection.Close();
return(false);
}
}
public Boolean InsertarRegistro(Caj_DenominacionBE objDenominacion)
{
//SqlTransaction objSqlTransaction = objSqlConnection.BeginTransaction();
try
{
objSqlConnection.Open();
SqlCommand objSqlCommand = new SqlCommand("sp_ins_Caj_Denominacion_registrar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
// objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.Parameters.Add(new SqlParameter("@dt_fchRegistro", objDenominacion.dt_fchRegistro));
objSqlCommand.Parameters.Add(new SqlParameter("@vc_dscpDenominacion", objDenominacion.st_dscpDenominacion)); objSqlCommand.Parameters.Add(new SqlParameter("@b_ver", "true"));
objSqlCommand.ExecuteNonQuery();
//objSqlTransaction.Commit();
objSqlConnection.Close();
return(true);
}
catch (Exception e)
{
objSqlConnection.Close();
return(false);
}
}
