예제 #1
0
        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);
        }
예제 #2
0
        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));
            }
        }