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); }