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; } }