private void btnConnection_Click(object sender, RoutedEventArgs e)
{
try
{
string login = tbxLogin.Text;
string password = tbxPassword.Text;
string request = $"SELECT COUNT(cpt_login) FROM compte WHERE cpt_login = '******' AND cpt_pwd = MD5('{password}');";
CURS cs = new CURS(CURS.connectionString);
if (cs.Count(request) == "1")
{
CURS csSelectContributor = new CURS(CURS.connectionString);
request = $"SELECT collaborateur.cob_id, statut.sta_libelle FROM compte " +
$"INNER JOIN collaborateur ON compte.fk_cob_id = collaborateur.cob_id " +
$"INNER JOIN statut ON collaborateur.fk_sta_id = statut.sta_id " +
$"WHERE cpt_login = '******'";
csSelectContributor.ReqSelect(request);
UserSession.Id = csSelectContributor.Field("cob_id").ToString();
UserSession.Statut = csSelectContributor.Field("sta_libelle").ToString();
MainMenu f = new MainMenu();
this.Hide();
f.Show();
}
else
{
throw new Exception("Les identifiants sont incorrectes.");
}
}
catch (Exception E)
{
MessageBox.Show(E.Message);
}
}
public MainMenu()
{
InitializeComponent();
tbxVisitorMatricule.Text = UserSession.Id;
string request;
CURS cs = new CURS(CURS.connectionString);
request = $"SELECT * FROM rapport WHERE fk_cob_id = '{ tbxVisitorMatricule.Text }';";
cs.ReqSelect(request);
while (!cs.End())
{
dgdReports.Items.Add(new Report()
{
IdVisitor = cs.Field("fk_cob_id").ToString(),
IdReport = cs.Field("rap_id").ToString(),
IdPractitioner = cs.Field("fk_pra_id").ToString(),
VisiteDate = cs.Field("rap_dateVisite").ToString()
});
cs.suivant();
}
}