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 LoadData(int skip, int take) //Get data from database
{
using (KitDataContext db = new KitDataContext())
{
try
{
//Load data from database to local
db.Groups.Load();
GroupsList = db.Groups.Local.ToList();
//Get number of pages
textBoxPageNum.Text = _currPageNumber + "/" + _totalPages;
//Load DataGridView
LoadDataGridView(skip, take);
//Resize columns
ResizeColumn();
//Clear Textboxes
ClearBoxes();
//Split Pages
SplitPages();
textBoxPageNum.Text = 1 + "/" + _totalPages;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
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 LoadData() //Get data from database
{
using (KitDataContext db = new KitDataContext())
{
try
{
//Load data from database to local memory
db.Students.Load();
db.Groups.Load();
StudentsList = db.Students.Local.ToList();
//Load DataGridView
LoadDataGridView(dataGridViewStudentOnDb, StudentsList);
var result = db.Groups.Local
.Where(s => s.Id == _groupId)
.SelectMany(s => s.Students);
StudentsInGroupList = result.ToList();
LoadDataGridView(dataGridViewStudentInGroup, StudentsInGroupList);
//Resize columns
ResizeColumn();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (KitDataContext db = new KitDataContext())
{
Random rand = new Random();
int random = rand.Next(1, db.Students.Count() - 1);
var result = db.Students
.OrderBy(s => s.Id)
.Skip(random)
.Take(1)
.Select(s => new
{
s.Id,
s.Name,
s.Contact.PhoneNumber,
s.Class,
s.Gender,
s.DateOfBirth,
s.Contact.Email
});
dataGridView.DataSource = result.ToList();
dataGridView.ClearSelection();
dataGridView.Columns[5].DefaultCellStyle.Format = "dd/MM/yyyy";
}
}
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 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 textBoxSearchByName_TextChanged(object sender, EventArgs e)
{
using (KitDataContext db = new KitDataContext())
{
var result = GroupsList
.Where(s => s.Name.Contains(toolStripTxtBoxSearch.Text))
.Select(s => new
{
s.Id,
s.Name,
s.Description
});
dataGridViewGroup.DataSource = result.ToList();
ResizeColumn();
dataGridViewGroup.ClearSelection();
}
}
private void dataGridViewGroup_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int rowNo = e.RowIndex;
ClearBoxes();
if (rowNo > -1)
{
textBoxID.Text = dataGridViewGroup.Rows[rowNo].Cells[0].Value.ToString();
int id = Convert.ToInt32(textBoxID.Text);
using (KitDataContext db = new KitDataContext())
{
var result = db.Groups
.FirstOrDefault(s => s.Id == id);
dataGridViewMember.DataSource = result.Students.Select(s => new
{
s.Id,
s.Name,
s.DateOfBirth,
s.Class
}).ToList();
dataGridViewMember.Columns[2].DefaultCellStyle.Format = "dd/MM/yyyy";
}
if (dataGridViewGroup.Rows[rowNo].Cells[1].Value != null)
{
_oldName = textBoxGroupName.Text = dataGridViewGroup.Rows[rowNo].Cells[1].Value.ToString();
}
if (dataGridViewGroup.Rows[rowNo].Cells[2].Value != null)
{
textBoxDescription.Text = dataGridViewGroup.Rows[rowNo].Cells[2].Value.ToString();
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
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 textBoxSearchByName_TextChanged(object sender, EventArgs e)
{
using (KitDataContext db = new KitDataContext())
{
var result = StudentsList
.Where(s => s.Name.ToLower().Contains(toolStripTxtBoxSearch.Text.ToLower()))
.Select(s => new
{
s.Id,
s.Name,
s.Contact.PhoneNumber,
s.Class,
s.Gender,
s.DateOfBirth,
s.Contact.Email
});
dataGridView.DataSource = result.ToList();
ResizeColumn();
dataGridView.ClearSelection();
}
}
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);
}
}
