public bool LogInTrial()
{
pictureBox_image.BackgroundImage = Resources.sadFace;
AccessDB db = new AccessDB(Settings.Default.DBpath);
if (!db.Connect(Program.DATABASE_PASSWORD))
{
DialogForm d = new DialogForm("כשל התחברות", "לא הצלחתי להתחבר למסד נתונים", false);
d.ShowDialog();
return(false);
}
int i = fullnames.IndexOf(textBox_user.Text);
if (i == -1)
{
DialogForm d = new DialogForm("כשל התחברות", "שם משתמש לא קיים", false);
d.ShowDialog();
return(false);
}
string ID = programUsers[i].personalNumber;
string pass = textBox_pass.Text;
List <Hashtable> tb = db.GetTableWithCriteria("ProgramUsers", new List <string> {
"ID"
}, new List <string> {
ID
});
if (tb.Count == 0)
{
DialogForm d = new DialogForm("כשל התחברות", "שם משתמש לא קיים במסד נתונים", false);
d.ShowDialog();
return(false);
}
string destp = tb[0]["Password"].ToString();
if (pass == destp)
{
pictureBox_image.BackgroundImage = Resources.happyface;
currentUser = programUsers[i];
return(true);
}
else
{
DialogForm d = new DialogForm("כשל התחברות", "סיסמא לא נכונה", false);
d.ShowDialog();
}
return(false);
}
private void LoadUsers()
{
programUsers = new List <ProgramUser>();
AccessDB db = new AccessDB(Settings.Default.DBpath);
if (!db.Connect(Program.DATABASE_PASSWORD))
{
DialogForm d = new DialogForm("כשל התחברות", "לא הצלחתי להתחבר למסד נתונים", false);
pictureBox_image.BackgroundImage = Resources.sadFace;
d.ShowDialog();
return;
}
Program.metadata = new Hashtable();
List <Hashtable> tempList = db.GetTable("Metadata");
if (tempList == null)
{
DialogForm d = new DialogForm("כשל התחברות", "לא הצלחתי לקרוא את Metadata", false);
pictureBox_image.BackgroundImage = Resources.sadFace;
d.ShowDialog();
return;
}
Program.metadata = tempList[0];
List <string> autoComp = new List <string>();
List <Hashtable> users = db.GetTable("ProgramUsers");
fullnames = new List <string>();
db.Disconnect();
foreach (Hashtable user in users)
{
string id = user["ID"].ToString();
string fname = user["FirstName"].ToString();
string lname = user["LastName"].ToString();
string position = user["Position"].ToString();
string rank = user["Rank"].ToString();
string comp = user["Compartment"].ToString();
string shiftIndex = "0";
try
{
shiftIndex = user["TeamsInCharge"].ToString();
}
catch (Exception)
{
db.Disconnect();
}
ProgramUser temp = new ProgramUser(fname, lname, id, position, rank, comp, shiftIndex);
autoComp.Add(temp.fullName);
fullnames.Add(temp.fullName);
programUsers.Add(temp);
}
var auto = new AutoCompleteStringCollection();
auto.AddRange(autoComp.ToArray());
if (textBox_user.InvokeRequired)
{
textBox_user.Invoke(new Action(() => textBox_user.AutoCompleteCustomSource = auto));
}
else
{
textBox_user.AutoCompleteCustomSource = auto;
}
loadingCircle_Loading.Active = false;
if (textBox_user.InvokeRequired)
{
textBox_user.Invoke(new Action(() => loadingCircle_Loading.Visible = false));
}
if (button_Yes.InvokeRequired)
{
button_Yes.Invoke(new Action(() => button_Yes.Visible = true));
}
}