private void Delete(int id) { try { using (KitDataContext db = new KitDataContext()) { var result = from s in db.Groups where s.Id == id select s; var deleteItems = result.ToList(); foreach (var deleteItem in deleteItems) { db.Groups.Remove(deleteItem); } db.SaveChanges(); } } catch (Exception e) { MessageBox.Show(e.Message); } }
private void Modify() { try { using (KitDataContext db = new KitDataContext()) { var result = db.Students.Find(_oldId); if (!result.Id.Equals(textBoxID.Text)) { Delete(result.Id); AddData(); } else { result.Name = textBoxName.Text; result.Class = textBoxClass.Text; result.DateOfBirth = DateTime.Parse(dateTimePicker.Value.ToString()); result.Contact.PhoneNumber = textBoxPhoneNum.Text; result.Contact.Email = textBoxEmail.Text; result.Gender = SetGender(); } db.SaveChanges(); //MessageBox.Show("Sửa thành viên thành công!", Program.applicationName); dataGridView.Refresh(); } } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void AddData() { try { if (textBoxGroupName.Text != String.Empty) { using (KitDataContext db = new KitDataContext()) { Group newGroup = new Group() { Name = textBoxGroupName.Text, Description = textBoxDescription.Text, Students = new List <Student>() }; db.Groups.Add(newGroup); db.SaveChanges(); } LoadData(0, _take); } } catch (Exception e) { MessageBox.Show(e.Message); } }
private void buttonLogin_Click(object sender, EventArgs e) { try { using (KitDataContext db = new KitDataContext()) { var salt = BCrypt.Net.BCrypt.GenerateSalt(); var pepper = "CsUd9KpJVD"; string username = textBoxUsername.Text; string password = textBoxPassword.Text; var resultStudent = db.Students.FirstOrDefault(s => s.Id.Equals(username)); var resultUser = db.Users.FirstOrDefault(s => s.Id.Equals(username)); if (resultUser == null) { if (resultStudent != null) { db.Users.Add(new User() { Id = resultStudent.Id, Password = BCrypt.Net.BCrypt.HashPassword(pepper + password, salt), Priority = Priority.User, Salt = salt }); db.SaveChanges(); } else { this.labelWrongInfo.Visible = true; } } else { var user = db.Users.FirstOrDefault(s => s.Id.Equals(username)); if (BCrypt.Net.BCrypt.Verify(pepper + password, user.Password) && user.Priority == Priority.Admin) { Thread thrd = new Thread(() => { using (WelcomeForm welcomeForm = new WelcomeForm()) { Application.Run(welcomeForm); } }); thrd.Start(); this.Dispose(); } else { this.labelWrongInfo.Visible = true; } } } } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void buttonRemove_Click(object sender, EventArgs e) { string id = dataGridViewStudentInGroup.Rows[_rowNo].Cells[0].Value.ToString(); var student = StudentsList.FirstOrDefault(s => s.Id.Equals(id)); using (KitDataContext db = new KitDataContext()) { var result = db.Groups.Find(_groupId); var stu = db.Students.FirstOrDefault(s => s.Id.Equals(student.Id)); result.Students.Remove(stu); db.SaveChanges(); } LoadData(); }
private void Delete(String id) { try { using (KitDataContext db = new KitDataContext()) { var result = db.Students.FirstOrDefault(s => s.Id.Equals(id)); var user = db.Users.FirstOrDefault(s => s.Id.Equals(id)); db.Users.Remove(user); db.Students.Remove(result); db.SaveChanges(); } } catch (Exception e) { MessageBox.Show(e.Message); } }
private void AddData() { try { if (textBoxID.Text != String.Empty && textBoxName.Text != string.Empty) { using (KitDataContext db = new KitDataContext()) { var pepper = "CsUd9KpJVD"; var salt = BCrypt.Net.BCrypt.GenerateSalt(); Student newMember = new Student() { Id = textBoxID.Text, Name = textBoxName.Text, DateOfBirth = dateTimePicker.Value, Class = textBoxClass.Text, Gender = SetGender(), Contact = new Contact() { PhoneNumber = textBoxPhoneNum.Text, Email = textBoxEmail.Text }, User = new User() { Password = BCrypt.Net.BCrypt.HashPassword(pepper + dateTimePicker.Value.Date, salt), Salt = salt, Priority = Priority.User } }; db.Students.Add(newMember); db.SaveChanges(); } LoadData(0, _take); } } catch (Exception e) { MessageBox.Show(e.Message); } }
private void buttonAdd_Click(object sender, EventArgs e) { try { string id = dataGridViewStudentOnDb.Rows[_rowNo].Cells[0].Value.ToString(); using (KitDataContext db = new KitDataContext()) { var result = db.Groups.Find(_groupId); var stu = db.Students.FirstOrDefault(s => s.Id.Equals(id)); result.Students.Add(stu); db.SaveChanges(); } LoadData(); } catch (Exception exception) { MessageBox.Show(exception.ToString()); } }
private void Modify() { try { using (KitDataContext db = new KitDataContext()) { var result = db.Groups.Find(textBoxID.Text); if (!(result.Name.Equals(textBoxGroupName.Text) || result.Description.Equals(textBoxDescription.Text))) { result.Name = textBoxGroupName.Text; result.Description = textBoxDescription.Text; } db.SaveChanges(); dataGridViewGroup.Refresh(); } } catch (Exception exception) { MessageBox.Show(exception.Message); } }