public int InsertarTRG_Riesgos(TRG_RiesgosBE _TRG_RiesgosBE)
{
int IdElementoClave = -1;
SqlParameter par1;
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_InsertarTRG_Riesgos";
cmd.CommandType = CommandType.StoredProcedure;
try
{
par1 = cmd.Parameters.Add(new SqlParameter("@Riesgo_desc", SqlDbType.VarChar, 550));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Riesgo_desc"].Value = _TRG_RiesgosBE.Riesgo_desc;
par1 = cmd.Parameters.Add(new SqlParameter("@Departamento_id", SqlDbType.SmallInt));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Departamento_id"].Value = _TRG_RiesgosBE.Departamento_id;
par1 = cmd.Parameters.Add(new SqlParameter("@Valor", SqlDbType.Int));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Valor"].Value = _TRG_RiesgosBE.Valor;
SqlParameter par4 = cmd.Parameters.Add("@@identity", SqlDbType.Int);
par4.Direction = ParameterDirection.ReturnValue;
cnx.Open();
int n = cmd.ExecuteNonQuery();
if (n > 0)
{
IdElementoClave = (int)par4.Value;
}
}
catch (SqlException x)
{
IdElementoClave = -1;
}
catch (Exception x)
{
IdElementoClave = -1;
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(IdElementoClave);
}
public List <TRG_RiesgosBE> ListarTRG_RiesgosByDepartamento(short _Departamento_id)
{
string conexion = MiConexion.GetCnx();
List <TRG_RiesgosBE> lTRG_RiesgosBE = null;
try
{
SqlConnection con = new SqlConnection(conexion);
con.Open();
SqlCommand cmd = new SqlCommand("sp_ListarTRG_RiesgosByDepartamento", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Departamento_id", SqlDbType.SmallInt));
cmd.Parameters["@Departamento_id"].Value = _Departamento_id;
SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.SingleResult);
if (drd != null)
{
lTRG_RiesgosBE = new List <TRG_RiesgosBE>();
int posRiesgo_id = drd.GetOrdinal("Riesgo_id");
int posRiesgo_desc = drd.GetOrdinal("Riesgo_desc");
int posDepartamento_id = drd.GetOrdinal("Departamento_id");
int posValor = drd.GetOrdinal("Valor");
int posActivo = drd.GetOrdinal("Activo");
TRG_RiesgosBE obeCategoriaBE = null;
while (drd.Read())
{
obeCategoriaBE = new TRG_RiesgosBE();
obeCategoriaBE.Riesgo_id = drd.GetInt32(posRiesgo_id);
obeCategoriaBE.Riesgo_desc = drd.GetString(posRiesgo_desc);
obeCategoriaBE.Departamento_id = drd.GetInt16(posDepartamento_id);
obeCategoriaBE.Valor = drd.GetInt32(posValor);
obeCategoriaBE.activo = drd.GetBoolean(posActivo);
lTRG_RiesgosBE.Add(obeCategoriaBE);
}
drd.Close();
}
con.Close();
}
catch (SqlException ex)
{
}
catch (Exception ex)
{
}
return(lTRG_RiesgosBE);
}
//public int InsertarTRG_Riesgos(TRG_RiesgosBE _TRG_RiesgosBE)
//{
// cnx.ConnectionString = MiConexion.GetCnx();
// cmd.Connection = cnx;
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText = "sp_InsertarTRG_Riesgos";
// SqlParameter par1;
// int _Categoria_id;
// try
// {
// par1 = cmd.Parameters.Add(new SqlParameter("@Riesgo_desc", SqlDbType.VarChar, 550));
// par1.Direction = ParameterDirection.Input;
// cmd.Parameters["@Riesgo_desc"].Value = _TRG_RiesgosBE.Riesgo_desc;
// par1 = cmd.Parameters.Add(new SqlParameter("@Departamento_id", SqlDbType.SmallInt));
// par1.Direction = ParameterDirection.Input;
// cmd.Parameters["@Departamento_id"].Value = _TRG_RiesgosBE.Departamento_id;
// par1 = cmd.Parameters.Add(new SqlParameter("@Valor", SqlDbType.Int));
// par1.Direction = ParameterDirection.Input;
// cmd.Parameters["@Valor"].Value = _TRG_RiesgosBE.Valor;
// SqlParameter par4 = cmd.Parameters.Add("@@identity", SqlDbType.Int);
// par4.Direction = ParameterDirection.ReturnValue;
// cnx.Open();
// int n = cmd.ExecuteNonQuery();
// if (n > 0) _Categoria_id = (int)par4.Value;
// cnx.Open();
// dtr = cmd.ExecuteReader();
// dtr.Read();
// _Categoria_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("@@identity")));
// }
// catch (SqlException x)
// {
// _Categoria_id = 0;
// }
// catch (Exception x)
// {
// _Categoria_id = 0;
// }
// finally
// {
// if (cnx.State == ConnectionState.Open)
// {
// cnx.Close();
// }
// cmd.Parameters.Clear();
// }
// return _Categoria_id;
//}
public bool ActualizarTRG_Riesgos(TRG_RiesgosBE _TRG_RiesgosBE)
{
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_ActualizarTRG_Riesgos";
SqlParameter par1;
bool _vcod;
try
{
par1 = cmd.Parameters.Add(new SqlParameter("@Riesgo_id", SqlDbType.Int));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Riesgo_id"].Value = _TRG_RiesgosBE.Riesgo_id;
par1 = cmd.Parameters.Add(new SqlParameter("@Riesgo_desc", SqlDbType.VarChar, 550));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Riesgo_desc"].Value = _TRG_RiesgosBE.Riesgo_desc;
par1 = cmd.Parameters.Add(new SqlParameter("@Departamento_id", SqlDbType.SmallInt));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Departamento_id"].Value = _TRG_RiesgosBE.Departamento_id;
par1 = cmd.Parameters.Add(new SqlParameter("@Valor", SqlDbType.SmallInt));
par1.Direction = ParameterDirection.Input;
cmd.Parameters["@Valor"].Value = _TRG_RiesgosBE.Valor;
cnx.Open();
cmd.ExecuteNonQuery();
_vcod = true;
}
catch (SqlException x)
{
_vcod = false;
}
catch (Exception x)
{
_vcod = false;
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(_vcod);
}
public TRG_RiesgosBE TraerTRG_RiesgosById(int _Riesgo_id)
{
TRG_RiesgosBE _TRG_RiesgosBE = new TRG_RiesgosBE();
DataSet dts = new DataSet();
try
{
cnx.ConnectionString = MiConexion.GetCnx();
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_TraerTRG_RiesgosById";
cmd.Parameters.Add(new SqlParameter("@Riesgo_id", SqlDbType.Int));
cmd.Parameters["@Riesgo_id"].Value = _Riesgo_id;
cnx.Open();
dtr = cmd.ExecuteReader();
if (dtr.HasRows == true)
{
dtr.Read();
var _with1 = _TRG_RiesgosBE;
_with1.Riesgo_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Riesgo_id")));
_with1.Riesgo_desc = dtr.GetValue(dtr.GetOrdinal("Riesgo_desc")).ToString();
_with1.Departamento_id = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Departamento_id")));
_with1.Valor = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Valor")));
_with1.activo = Convert.ToBoolean(dtr.GetValue(dtr.GetOrdinal("activo")));
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(_TRG_RiesgosBE);
}
public bool ActualizarTRG_Riesgos(TRG_RiesgosBE _inseBE)
{
return(_TRG_RiesgosADO.ActualizarTRG_Riesgos(_inseBE));
}
public int InsertarTRG_Riesgos(TRG_RiesgosBE _inseBE)
{
return(_TRG_RiesgosADO.InsertarTRG_Riesgos(_inseBE));
}
