public ClsDataSets.DS_TBC_SIS Detalle(string Id, string DescMenu, string Descripcion, int OrdenMenu,
string UsuaCrea, DateTime FechCrea, string UsuaActu, DateTime FechActu, int OpcionConsulta)
{
ClsDataSets.DS_TBC_SIS objDataSet = new ClsDataSets.DS_TBC_SIS();
try
{
ObjConnection = new SqlConnection(_ConexionData);
ObjAdapter = new SqlDataAdapter("SP_TBC_MENU_SISTEMA_GetByAll", ObjConnection);
ObjParam = new SqlParameter();
ObjAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
ObjAdapter.SelectCommand.Parameters.AddWithValue("@ID", Id);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_DESC_MENU", DescMenu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_DESCRIPCION", Descripcion);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@NM_ORDEN_MENU", OrdenMenu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_CREA", UsuaCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_CREA", FechCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_ACTU", UsuaActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_ACTU", FechActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@OPCI_CONS", OpcionConsulta);
ObjAdapter.Fill(objDataSet, "TBC_MENU_SISTEMA");
ObjConnection.Close();
if (ObjConnection.State != ConnectionState.Closed)
{
ObjConnection.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(objDataSet);
}
public ClsDataSets.DS_TBC_SIS Detalle(int Id, string MailFrom, string MailHead, string smtp, int Port,
string Mail, string Pass,
string UsuaCrea, DateTime FechCrea, string UsuaActu, DateTime FechActu, int OpcionConsulta)
{
ClsDataSets.DS_TBC_SIS objDataSet = new ClsDataSets.DS_TBC_SIS();
try
{
ObjConnection = new SqlConnection(_ConexionData);
ObjAdapter = new SqlDataAdapter("SP_TBC_CONF_MAIL_GetByAll", ObjConnection);
ObjParam = new SqlParameter();
ObjAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
ObjAdapter.SelectCommand.Parameters.AddWithValue("@ID", Id);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_MAIL_FROM", MailFrom);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_MAIL_HEAD", MailHead);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_SMTP", smtp);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_PORT", Port);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_MAIL", Mail);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_PASSWORD", Pass);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_CREA", UsuaCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_CREA", FechCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_ACTU", UsuaActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_ACTU", FechActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@OPCI_CONS", OpcionConsulta);
ObjAdapter.Fill(objDataSet, "TBC_CONF_MAIL");
ObjConnection.Close();
if (ObjConnection.State != ConnectionState.Closed)
{
ObjConnection.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(objDataSet);
}
public ClsDataSets.DS_TBC_SIS Detalle(string IdPerfilUsuario, string IdCodiSist, string IdMenuSistema,
string IdOpcionSistema, double CorrConfOpciSist, double CorrOpciSistPerfil, string Descripcion,
string UsuaCrea, DateTime FechCrea, string UsuaActu, DateTime FechActu, int OpcionConsulta)
{
ClsDataSets.DS_TBC_SIS objDataSet = new ClsDataSets.DS_TBC_SIS();
try
{
ObjConnection = new SqlConnection(_ConexionData);
ObjAdapter = new SqlDataAdapter("SP_TBC_OPCI_SIST_PERFIL_GetByAll", ObjConnection);
ObjParam = new SqlParameter();
ObjAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
ObjAdapter.SelectCommand.Parameters.AddWithValue("@ID_PERFIL_USUARIO", IdPerfilUsuario);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@ID_CODI_SIST", IdCodiSist);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@ID_MENU_SISTEMA", IdMenuSistema);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@ID_OPCION_SISTEMA", IdOpcionSistema);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@NM_CORR_CONF_OPCI_SIST", CorrConfOpciSist);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@NM_CORR_OPCI_SIST_PERFIL", CorrOpciSistPerfil);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_DESCRIPCION", Descripcion);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_CREA", UsuaCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_CREA", FechCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_ACTU", UsuaActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_ACTU", FechActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@OPCI_CONS", OpcionConsulta);
ObjAdapter.Fill(objDataSet, "TBC_OPCI_SIST_PERFIL");
ObjConnection.Close();
if (ObjConnection.State != ConnectionState.Closed)
{
ObjConnection.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(objDataSet);
}
public ClsDataSets.DS_TBC_SIS Detalle(string Id, string NombrePerfil, string Descripcion, char EstadoPerfil,
string UsuaCrea, DateTime FechCrea, string UsuaActu, DateTime FechActu, int OpcionConsulta)
{
ClsDataSets.DS_TBC_SIS objDataSet = new ClsDataSets.DS_TBC_SIS();
try
{
ObjConnection = new SqlConnection(_ConexionData);
ObjAdapter = new SqlDataAdapter("SP_TBC_PERFIL_USUARIO_GetByAll", ObjConnection);
ObjParam = new SqlParameter();
ObjAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
ObjAdapter.SelectCommand.Parameters.AddWithValue("@ID", Id);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_NOMBRE_PERFIL", NombrePerfil);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@DS_DESCRIPCION", Descripcion);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@CD_ESTADO_PERFIL", EstadoPerfil);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_CREA", UsuaCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_CREA", FechCrea);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@USUA_ACTU", UsuaActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@FECH_ACTU", FechActu);
ObjAdapter.SelectCommand.Parameters.AddWithValue("@OPCI_CONS", OpcionConsulta);
ObjAdapter.Fill(objDataSet, "TBC_PERFIL_USUARIO");
ObjConnection.Close();
if (ObjConnection.State != ConnectionState.Closed)
{
ObjConnection.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(objDataSet);
}
