Esempio n. 1
0
        private void btNextCompany_Click(object sender, EventArgs e)
        {
            try
            {
                if (companyname != null && SignIn.IfExistsUsername(companyname) == true)
                {
                    throw new Exception("Company already exist!");
                }
                else if (passC != null && SignIn.Conditions(passC) == false)
                {
                    throw new Exception("Parola nu corespunde conditiilor!");
                }
                else if (passC != null && checkpassC != null && passC.Equals(checkpassC) == false)
                {
                    throw new Exception("Password dosen't match!");
                }
                else if (emailC != null && SignIn.ValidEmailAddress(emailC) == false)
                {
                    throw new Exception("E-mail address must be valid e-mail address format!");
                }

                else if (SignIn.IfExistsEmail(emailC) == true)
                {
                    throw new Exception("Email already exist!");
                }
                else if (companyname != null && CEO != null &&
                         addressC != null && phoneC != null &&
                         emailC != null && skillsC != null &&
                         passC != null && checkpassC != null)
                {
                    throw new Exception("Register successfully!");
                    this.Close();
                    CCompanie.inregistreaza_companie(CEO, companyname, addressC, emailC, phoneC, passC);
                    Form form = new CCompanie(CEO, companyname, addressC, emailC, phoneC, get_skillsC());
                    form.Show();
                }
                else
                {
                    throw new Exception("Some empty filled!");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Esempio n. 2
0
        private void btLogIn_Click(object sender, EventArgs e)
        {
            try
            {
                if (password == null || username == null)
                {
                    if (password == null && username != null)
                    {
                        throw new Exception("Please write the password");
                    }
                    else if (username == null && password != null)
                    {
                        throw new Exception("Please write the username");
                    }
                    else
                    {
                        throw new Exception("Please write the username and the password");
                    }
                }
                else if (username != null && password != null)
                {
                    username = txtUsername.Text.ToString();
                    password = txtPassoword.Text.ToString();

                    if (IfCompany(username, password) == true)
                    {
                        var context = new LinkedinEntities5();
                        var results = from c in context.Companie
                                      where c.UsernameC.Equals(username)
                                      select new
                        {
                            c.ID_Companie,
                            c.Director_companie,
                            c.Adresa_companie,
                            c.Email_companie,
                            c.Telefon_companie
                        };

                        foreach (var item in results)
                        {
                            string director    = item.Director_companie;
                            string adresa      = item.Adresa_companie;
                            string email       = item.Email_companie;
                            string telefon     = item.Telefon_companie;
                            int    id_companie = item.ID_Companie;

                            Form form = new CCompanie(director, username, adresa, email, telefon, skillsC(id_companie));
                            form.Show();
                        }
                    }
                    else if (IfClient(username, password) == true)
                    {
                        var context = new LinkedinEntities5();
                        var results = from c in context.Client
                                      where c.Username.Equals(username)
                                      select new
                        {
                            c.ID_Client,
                            c.Nume,
                            c.Prenume,
                            c.Data_Nasterii,
                            c.Email,
                            c.Poza,
                            c.Facultate_absolvita,
                            c.ID_sex,
                            c.ID_statut_social,
                            c.Adresa,
                            c.Telefon,
                            c.Nationalitate,
                            c.Limbi_straine
                        };

                        foreach (var item in results)
                        {
                            string nume          = item.Nume;
                            string prenume       = item.Prenume;
                            string email         = item.Email;
                            string facultate     = item.Facultate_absolvita;
                            string adresa        = item.Adresa;
                            string telefon       = item.Telefon;
                            string nationalitate = item.Nationalitate;
                            string limbi_straine = item.Limbi_straine;
                            string data          = Convert.ToString(item.Data_Nasterii);
                            int    id_client     = item.ID_Client;
                            string sex;
                            string statut = null;
                            if (item.ID_sex.Equals(1))
                            {
                                sex = "Male";
                            }
                            else
                            {
                                sex = "Female";
                            }

                            if (item.ID_statut_social.Equals(1))
                            {
                                statut = "Single";
                            }
                            else if (item.ID_statut_social.Equals(2))
                            {
                                statut = "In a relationship";
                            }
                            else if (item.ID_statut_social.Equals(3))
                            {
                                statut = "It's complicated";
                            }
                            else if (item.ID_statut_social.Equals(4))
                            {
                                statut = "Widow";
                            }
                            else if (item.ID_statut_social.Equals(5))
                            {
                                statut = "Divorced";
                            }
                            else if (item.ID_statut_social.Equals(6))
                            {
                                statut = "Marriage";
                            }
                            Image result = ConvertByteToImage(item.Poza);

                            Form form = new CClient(nume, prenume, username, telefon, email, data, facultate, adresa, sex, statut, nationalitate, skills(id_client), result);
                            form.Show();
                        }
                    }
                    else
                    {
                        throw new Exception("Username or password invalid");
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }