private void btnUpdate_Click(object sender, EventArgs e)
{
using (var context = new Session4Entities())
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
var trainingID = Convert.ToInt32(dataGridView1.Rows[row.Index].Cells[5].Value);
var getTraining = (from x in context.Assign_Training
where x.trainingId == trainingID
select x).FirstOrDefault();
getTraining.progress = Convert.ToInt32(dataGridView1.Rows[row.Index].Cells[4].Value);
}
context.SaveChanges();
MessageBox.Show("Training progress updated successfully!", "Update training progress",
MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadData();
}
}
private void btnAssign_Click(object sender, EventArgs e)
{
using (var context = new Session4Entities())
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
var skill = dataGridView1.Rows[row.Index].Cells[0].Value.ToString();
var category = dataGridView1.Rows[row.Index].Cells[1].Value.ToString();
var getSkillID = (from x in context.Skills
where x.skillName == skill
select x.skillId).FirstOrDefault();
var getUserTypeID = (from x in context.User_Type
where x.userTypeName == category
select x.userTypeId).FirstOrDefault();
var getTrainees = (from x in context.Users
where x.skillIdFK == getSkillID && x.userTypeIdFK == getUserTypeID
select x);
foreach (var item in getTrainees)
{
var newTraining = new Assign_Training()
{
moduleIdFK = Convert.ToInt32(dataGridView1.Rows[row.Index].Cells[4].Value),
progress = 0,
startDate = Convert.ToDateTime(dataGridView1.Rows[row.Index].Cells[3].Value),
userIdFK = item.userId
};
context.Assign_Training.Add(newTraining);
}
}
context.SaveChanges();
MessageBox.Show("Trainings assigned successfully!", "Assign Training",
MessageBoxButtons.OK, MessageBoxIcon.Information);
Hide();
(new AdminMain()).ShowDialog();
Close();
}
}
private void btnUpload_Click(object sender, EventArgs e)
{
using (var context = new Session4Entities())
{
var lines = File.ReadAllLines(txtFilePath.Text);
foreach (var item in lines.Skip(1))
{
var values = item.Split(',');
var newUser = new User()
{
userId = values[0],
skillIdFK = Int32.Parse(values[1]),
passwd = values[2],
name = values[3],
userTypeIdFK = Int32.Parse(values[4])
};
context.Users.Add(newUser);
}
context.SaveChanges();
MessageBox.Show("Successfully added users!", "Upload Users", MessageBoxButtons.OK,
MessageBoxIcon.Information);
txtFilePath.Text = string.Empty;
}
}
