public static List <string> FazerLogin(string Email, string Senha, ref Postgre _Pg) { List <string> Retorno = new List <string>(); string SQL = @" SELECT usua_id, (CASE WHEN usua_tipo IS NULL THEN 'USUARIO' ELSE usua_tipo END) AS tipo, usua_nome FROM usuario WHERE usua_email='" + Email + "' AND usua_senha='" + Senha + @"' AND excluido=FALSE"; //fazer login DataTable Tabela = _Pg.ObterTabela(SQL); string TipoUsuario = String.Empty; string NomeUsuario = String.Empty; string URLLoginInvalido = String.Empty; if (Tabela.Rows.Count >= 1) { TipoUsuario = JJZ.Dados.DataUtil.ParaBase64(JJZ.Dados.DataUtil.ParaBase64(Tabela.Rows[0]["tipo"].ToString())); NomeUsuario = Tabela.Rows[0]["clie_nomefantasia"].ToString(); } else { URLLoginInvalido = "/AcessoSeguro.aspx?M=" + JJZ.Dados.DataUtil.ParaBase64("LoginInvalido"); } Retorno.Add(TipoUsuario); //1 Retorno.Add(NomeUsuario); //2 Retorno.Add(Email); //3 Retorno.Add(URLLoginInvalido); //4 return(Retorno); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); try { _Pg = new Postgre("consultorio"); //Postgre Pg = new Postgre(ConfigurationManager.AppSettings["Schema"]); //Postgre Banco = new Postgre("consultorio"); //_Pg = new BancoPgSQL(ConfigurationManager.AppSettings["StringConexao"],ConfigurationManager.AppSettings["Schema"]); //_IDUsuario = Convert.ToInt32(Session["IDUsuario"].ToString()); _AdmLogado = _IDUsuario == 0 ? false : true; _IDUsuario = Convert.ToInt32(Session["autenticacao_atendimento_id_usuario"].ToString()); } catch { Response.Redirect("/AcessoSeguro/Login.aspx"); Response.End(); } if (_IDUsuario == 0) { Response.Redirect("/AcessoSeguro/Login.aspx"); Response.End(); } }
private void ButtonAccept_Click(object sender, RoutedEventArgs e) { //создание нового клиента var client = new Client(NameBox.Text, DayBox.Text, MonthBox.Text, YearBox.Text, PhoneBox.Text); Postgre.ExecuteNonQuery(client.ToQueryAdd()); MainWindow.UpdateTable(); this.Close(); }
private void ListMemberships_Selected(object sender, RoutedEventArgs e) { AnotherListItemSelected(); UpdateTable = null; UpdateTable += UpdateTableMemberships; SPTable.Visibility = Visibility.Visible; Headline.Text = "Абонементы"; tTable.ItemsSource = Postgre.LoadMembershipsList().DefaultView; tTable.MouseLeftButtonUp += MembershipClicked; }
private void Button_Click(object sender, RoutedEventArgs e) { string login = LoginBox.Text; string password = PasswordBox.Password; if (Postgre.AutorizeUser(login, password)) { MainWindow mw = new MainWindow(); mw.Show(); this.Close(); } }
private void ListEquipment_Selected(object sender, RoutedEventArgs e) { AnotherListItemSelected(); UpdateTable = null; UpdateTable += UpdateTableEquipment; SPTable.Visibility = Visibility.Visible; Headline.Text = "Игровые системы"; Postgre.LoadEquipmentList(); tTable.ItemsSource = Postgre.Equipments.ToDataTable().DefaultView; btnNew.Click += CreateEquipment; //tTable.MouseLeftButtonUp += MembershipClicked; }
private void ListClients_Selected(object sender, RoutedEventArgs e) { AnotherListItemSelected(); UpdateTable = null; UpdateTable += UpdateTableClients; SPTable.Visibility = Visibility.Visible; Headline.Text = "Клиенты"; Postgre.LoadClientsList(); tTable.ItemsSource = Postgre.ClientsInfo.ToDataTable(true).DefaultView; btnNew.Click += CreateNewClient; //tTable.MouseDoubleClick += ClientClicked; }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); try { _Schema = Session["mix_schema"].ToString(); _Pg = new Postgre(_Schema); _IdUsuario = Convert.ToInt32(Session["autenticacaoid"].ToString()); } catch { Response.Redirect("/AcessoSeguro/Login.aspx"); Response.End(); } if (_IdUsuario == 0) { Response.Redirect("/AcessoSeguro/Login.aspx"); Response.End(); } }
private void ButtonAccept_Click(object sender, RoutedEventArgs e) { Postgre.ExecuteNonQuery(m.ToQueryActivate()); MainWindow.UpdateTable(); this.Close(); }
public WeatherForecastController(ILogger <WeatherForecastController> logger, Postgre db) { _logger = logger; _db = db; }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); _Pg = new Postgre("consultorio"); }
private void btn_Postgre_Insert_Click(object sender, RoutedEventArgs e) { Postgre postgre = new Postgre("211.216.239.90", "aton", "aton", "aton", 61003); var result = postgre.Insert("INSERT INTO test VALUES(1, '문제석')"); }
private void btn_Postgre_Select_Click(object sender, RoutedEventArgs e) { Postgre postgre = new Postgre("211.216.239.90", "aton", "aton", "aton", 61003); JSResults result = postgre.Select("SELECT * FROM authorityMenu"); }
public MainWindow() { Postgre.OpenConnection(); InitializeComponent(); AnotherListItemSelected(); }
public void UpdateTableEquipment() { Postgre.LoadEquipmentList(); tTable.ItemsSource = Postgre.Equipments.ToDataTable().DefaultView; }
public void UpdateTableMemberships() { tTable.ItemsSource = Postgre.LoadMembershipsList().DefaultView; }
public void UpdateTableClients() { Postgre.LoadClientsList(); tTable.ItemsSource = Postgre.ClientsInfo.ToDataTable(false).DefaultView; }