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