private void authButtom_Click(object sender, EventArgs e) { using (SearchProductsEntities db = new SearchProductsEntities()) { var pass = db.Users.Where(x => x.UserLogin == LoginTextBox.Text).FirstOrDefault(); if (pass != null) { if (String.Compare(pass.UserPassword, Crypto.Hash(PasswordTextBox.Text)) == 0) { CUser.CurrentUser = LoginTextBox.Text; CUser.UserPhoto = ImageConvertion.RetriveImage(pass.UserPhoto); CUser.City = pass.UserCity; CUser.UserName = pass.UserName; CUser.UserSName = pass.UserSecondName; CUser.RegDate = pass.UserRegistrationDate; if (isAdmin.Checked) { if (pass.UserAdminRights) { CUser.CurrentUser = LoginTextBox.Text; AdminForm1 af = new AdminForm1(); this.Hide(); af.Show(); } else { rightsErrorLabel.Visible = true; //Сообщение об ошибке } } else { CUser.CurrentUser = LoginTextBox.Text; MainForm mf = new MainForm(); this.Hide(); mf.Show(); } } else { wrongPassLabel.Visible = true; //Сообщение об ошибке } } else { wrongLoginLabel.Visible = true; //Сообщение об ошибке } } }
private void AddPhoto(object ofds) { OpenFileDialog ofd = (OpenFileDialog)ofds; try { #region Добавить в базу фото using (SearchProductsEntities db = new SearchProductsEntities()) { Users user = db.Users.Where(x => x.UserLogin == CUser.CurrentUser).FirstOrDefault(); user.UserPhoto = ImageConvertion.ConvertToByteArray(Image.FromFile(ofd.FileName)); db.SaveChanges(); // circularPictureBox1.Image = ImageConvertion.RetriveImage(user.UserPhoto); } #endregion } catch (OutOfMemoryException ex) { MessageBox.Show(ex.Message); } }