public void Initialize(DatabaseManager DBManager_O, UInt32 PersID_UL)
{
mDBManager_O = DBManager_O;
mPersID_UL = PersID_UL;
String Where_ST = "PersID=" + mPersID_UL;
if (mDBManager_O.mConnected_b)
{
TxtLogin.Text = mDBManager_O.GetTableField("Pers", "UserLogin", Where_ST);
TxtPwd.Text = mDBManager_O.GetTableField("Pers", "Pwd", Where_ST);
TxtConfirmPwd.Text = mDBManager_O.GetTableField("Pers", "Pwd", Where_ST);
DBComboxPrefDep.FillList(DBManager_O, "TypeDep", "TypeDepID", "TypeDepLib");
DBComboxPrefHall.FillList(DBManager_O, "Hall", "HallID", "HallName");
// Get user prefered dep and hall
UInt32 PrefDep_UL = 0;
UInt32 PrefHall_UL = 0;
UInt32.TryParse(DBManager_O.GetTableField("Pers", "PrefDepID", Where_ST), out PrefDep_UL);
UInt32.TryParse(DBManager_O.GetTableField("Pers", "PrefHallID", Where_ST), out PrefHall_UL);
// If prefered dep and hall found, select it in dep combo box
if (PrefDep_UL > 0)
{
DBComboxPrefDep.SelectItemByID(PrefDep_UL);
}
if (PrefHall_UL > 0)
{
DBComboxPrefHall.SelectItemByID(PrefHall_UL);
}
}
}
private void ToolStripBtnValidate_Click(object sender, EventArgs e)
{
bool LoginOK_b = false;
bool PwdOK_b = false;
bool PrefHallOK_b = false;
bool PrefDepOK_b = false;
UInt32 PrefHallID_UL, PrefDepID_UL;
if (mDBManager_O.mConnected_b)
{
// Check user login
LoginOK_b = !String.IsNullOrEmpty(TxtLogin.Text);
if (!LoginOK_b)
{
MessageBox.Show("Votre login ne peut être vide.", "Erreur !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// Check password
PwdOK_b = !String.IsNullOrEmpty(TxtPwd.Text) && !String.IsNullOrEmpty(TxtConfirmPwd.Text);
if (!PwdOK_b)
{
MessageBox.Show("Votre mot de passe ne peut être vide.", "Erreur !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
PwdOK_b = TxtConfirmPwd.Text.Equals(TxtPwd.Text);
if (!PwdOK_b)
{
MessageBox.Show("Votre mot de passe et sa confirmation ne sont pas identiques.", "Erreur !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Check pref hall
DBComboxPrefHall.GetSelectedItemID(out PrefHallID_UL);
PrefHallOK_b = (PrefHallID_UL > 0);
if (!PrefHallOK_b)
{
MessageBox.Show("Le hall préféré sélectionné n'est pas valide.", "Erreur !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// Check pref dep
DBComboxPrefDep.GetSelectedItemID(out PrefDepID_UL);
PrefDepOK_b = (PrefDepID_UL > 0);
if (!PrefDepOK_b)
{
MessageBox.Show("Le département préféré sélectionné n'est pas valide.", "Erreur !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (LoginOK_b && PwdOK_b && PrefHallOK_b && PrefDepOK_b)
{
List <String> Param_O = new List <String>();
List <Object> Values_O = new List <Object>();
String SQLCommand_st = @"UPDATE Pers SET UserLogin=@UserLogin, Pwd=@Pwd, PrefHallID=@PrefHallID, PrefDepID=@PrefDepID
WHERE PersID=@PersID";
Param_O.Add("@UserLogin");
Param_O.Add("@Pwd");
Param_O.Add("@PrefHallID");
Param_O.Add("@PrefDepID");
Param_O.Add("@PersID");
Values_O.Add(TxtLogin.Text);
Values_O.Add(TxtPwd.Text);
Values_O.Add((int)PrefHallID_UL);
Values_O.Add((int)PrefDepID_UL);
Values_O.Add((int)mPersID_UL);
mDBManager_O.ExecuteRequest(SQLCommand_st, Param_O, Values_O);
this.Dispose();
}
}
}
