public int intGestionarPerfiles(Perfiles objPerfil, int iOpcion)
{
// ConnectionStringSettings strConexion = ConfigurationManager.ConnectionStrings["DefaultConnection"];
// Conexion objConexion = new Conexion();
SqlConnection sqlConnection1 = new SqlConnection("Data Source=192.168.9.77;Initial Catalog=sipaa_d;User ID=Desarrollo;Password=Desa17");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"sp_GestionPerfiles";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;
cmd.Parameters.Add("@CvPerfil", SqlDbType.Int).Value = objPerfil.CVPerfil;
cmd.Parameters.Add("@Descripcion", SqlDbType.VarChar).Value = objPerfil.Descripcion;
cmd.Parameters.Add("@UsuarioUMod", SqlDbType.VarChar).Value = objPerfil.UsuuMod;
cmd.Parameters.Add("@ProgramaUMod", SqlDbType.VarChar).Value = objPerfil.PrguMod;
cmd.Parameters.Add("@Opcion", SqlDbType.Int).Value = iOpcion;
sqlConnection1.Open();
int iResponse = Convert.ToInt32(cmd.ExecuteScalar());
sqlConnection1.Close();
return(iResponse);
}
// Conexion objConexion = new Conexion();
public Dictionary <int, string> ObtenerListPerfiles()
{
Dictionary <int, string> dcPerfiles = new Dictionary <int, string>();
// ConnectionStringSettings strConexion = ConfigurationManager.ConnectionStrings["DefaultConnection"];
SqlConnection sqlConnection1 = new SqlConnection("Data Source=192.168.9.77;Initial Catalog=sipaa_d;User ID=Desarrollo;Password=Desa17");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"SELECT [CVPERFIL]
,[DESCRIPCION]
,[USUUMOD]
,[FHUMOD]
,[PRGUMOD]
FROM[dbo].[ACCECPERFIL]";
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Perfiles objPerfiles = new Perfiles();
objPerfiles.CVPerfil = reader.GetInt32(reader.GetOrdinal("CVPERFIL"));
objPerfiles.Descripcion = reader.GetString(reader.GetOrdinal("DESCRIPCION"));
dcPerfiles.Add(objPerfiles.CVPerfil, objPerfiles.Descripcion);
}
sqlConnection1.Close();
return(dcPerfiles);
}
