private void LoadTrainee() { cbTrainingCat.Items.Clear(); using (var context = new Session4Entities()) { var getTraineeCat = (from x in context.User_Type select x.userTypeName).Distinct().ToList(); getTraineeCat.Remove("Admin"); cbTrainingCat.Items.AddRange(getTraineeCat.ToArray()); } }
private void LoadSkills() { cbSkill.Items.Clear(); using (var context = new Session4Entities()) { var getSkills = (from x in context.Skills select x.skillName).Distinct().ToList(); getSkills.Remove("Admin"); cbSkill.Items.AddRange(getSkills.ToArray()); } }
private void TrackCompetitor_Load(object sender, EventArgs e) { using (var context = new Session4Entities()) { var getSkill = (from x in context.Skills where x.skillId == _skillID select x.skillName).FirstOrDefault(); lblSkill.Text = getSkill; } LoadData(); }
private void cbSkill_SelectedIndexChanged(object sender, EventArgs e) { using (var context = new Session4Entities()) { var getSkillID = (from x in context.Skills where x.skillName == cbSkill.SelectedItem.ToString() select x.skillId).FirstOrDefault(); var getExpertNames = (from x in context.Users where x.skillIdFK == getSkillID && x.userTypeIdFK == 2 select x.name).ToArray(); cbExpertName.Items.AddRange(getExpertNames); } }
private void LoadCompetitors() { cbCompetitorName.Items.Clear(); using (var context = new Session4Entities()) { var getSkillID = (from x in context.Skills where x.skillName == cbSkill.SelectedItem.ToString() select x.skillId).FirstOrDefault(); var getCompetitors = (from x in context.Users where x.skillIdFK == getSkillID && x.userTypeIdFK == 3 select x.name).ToArray(); cbCompetitorName.Items.AddRange(getCompetitors); } }
private void btnLogin_Click(object sender, EventArgs e) { using (var context = new Session4Entities()) { if (string.IsNullOrWhiteSpace(txtUserID.Text) || string.IsNullOrWhiteSpace(txtPassword.Text)) { MessageBox.Show("Please check your fields!", "Empty Field(s)", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var findUser = (from x in context.Users where x.userId == txtUserID.Text select x).FirstOrDefault(); if (findUser == null) { MessageBox.Show("User does not exist!", "Invalid User", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (findUser.passwd != txtPassword.Text) { MessageBox.Show("User ID or Password does not match our DB!", "Invalid Login", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show($"Welcome {findUser.name}!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Information); if (findUser.userTypeIdFK == 2) { Hide(); (new ExpertMain(findUser.skillIdFK)).ShowDialog(); Close(); } else if (findUser.userTypeIdFK == 3) { Hide(); (new UpdateCompetitor()).ShowDialog(); Close(); } else { Hide(); (new AdminMain()).ShowDialog(); Close(); } } } } }
private void LoadData() { using (var context = new Session4Entities()) { var getModules = (from x in context.Assign_Training where x.User.skillIdFK == _skillID && x.User.userTypeIdFK == 3 select x.moduleIdFK).Distinct(); dataGridView1.ColumnCount = getModules.Count() + 1; dataGridView1.Columns[0].HeaderText = "Name of Competitor"; int i = 1; var getCompetitors = (from x in context.Users where x.skillIdFK == _skillID && x.userTypeIdFK == 3 select x.name).Distinct(); foreach (var modules in getModules) { var getModuleName = (from x in context.Training_Module where x.moduleId == modules select x.moduleName).FirstOrDefault(); dataGridView1.Columns[i].HeaderText = getModuleName; i += 1; } foreach (var competitors in getCompetitors) { var newRow = new List <string>() { competitors }; foreach (var modules in getModules) { var getProgress = (from x in context.Assign_Training where x.moduleIdFK == modules && x.User.name == competitors select x.progress).FirstOrDefault(); newRow.Add(getProgress.ToString()); } dataGridView1.Rows.Add(newRow.ToArray()); } foreach (DataGridViewRow row in dataGridView1.Rows) { foreach (DataGridViewColumn cell in dataGridView1.Columns) { if (dataGridView1[cell.Index, row.Index].Value.ToString() == "0") { dataGridView1[cell.Index, row.Index].Style.BackColor = Color.Red; } } } } }
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 btnAdd_Click(object sender, EventArgs e) { using (var context = new Session4Entities()) { var getSkillID = (from x in context.Skills where x.skillName == cbSkill.SelectedItem.ToString() select x.skillId).FirstOrDefault(); var getCategory = (from x in context.User_Type where x.userTypeName == cbTrainingCat.SelectedItem.ToString() select x.userTypeId).FirstOrDefault(); var getModule = (from x in context.Training_Module where x.skillIdFK == getSkillID && x.userTypeIdFK == getCategory where x.moduleName + " (" + x.durationDays + " days)" == cbTrainingModule.SelectedItem.ToString() select x).FirstOrDefault(); var endDuration = dtpStart.Value.AddDays(getModule.durationDays); var boolCheck = true; foreach (DataGridViewRow row in dataGridView1.Rows) { if (Convert.ToInt32(dataGridView1[4, row.Index].Value) == getModule.moduleId) { boolCheck = false; } } if (endDuration > endDate) { MessageBox.Show("Unable to assign training as date will be after start of competition!", "Assign Training", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (boolCheck == false) { MessageBox.Show("Unable to add duplicate!", "Assign Training", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var newRow = new List <string>() { cbSkill.SelectedItem.ToString(), cbTrainingCat.SelectedItem.ToString(), getModule.moduleName, dtpStart.Value.ToShortDateString(), getModule.moduleId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } }
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 4) { using (var context = new Session4Entities()) { var trainingID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[5].Value); var getOldProgress = (from x in context.Assign_Training where x.trainingId == trainingID select x.progress).FirstOrDefault(); if (!Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(), out _) || getOldProgress > Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value)) { MessageBox.Show("Please input a valid number higher than the old progress!", "Invalid Number", MessageBoxButtons.OK, MessageBoxIcon.Error); dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = getOldProgress; } } } }
private void LoadTrainingModules() { cbTrainingModule.Items.Clear(); using (var context = new Session4Entities()) { var getSkillID = (from x in context.Skills where x.skillName == cbSkill.SelectedItem.ToString() select x.skillId).FirstOrDefault(); var getCategory = (from x in context.User_Type where x.userTypeName == cbTrainingCat.SelectedItem.ToString() select x.userTypeId).FirstOrDefault(); var findUnassignedModules = (from x in context.Training_Module where x.skillIdFK == getSkillID && x.userTypeIdFK == getCategory && x.Assign_Training.Count == 0 select x); foreach (var item in findUnassignedModules) { cbTrainingModule.Items.Add($"{item.moduleName} ({item.durationDays} days)"); } } }
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 LoadGraph() { chart1.Series.Clear(); chart1.Series.Add("Completed"); chart1.Series.Add("In Progress"); chart1.Series.Add("Not Started"); using (var context = new Session4Entities()) { var getSkillID = (from x in context.Skills where x.skillName == cbSkill.SelectedItem.ToString() select x.skillId).FirstOrDefault(); var getAssignedTraining = (from x in context.Assign_Training select x).ToList(); var getDistinctCompetitorModule = (from x in getAssignedTraining where x.User.skillIdFK == getSkillID where x.User.userTypeIdFK == 3 select x.moduleIdFK).Distinct(); foreach (var item in getDistinctCompetitorModule) { var getModuleName = (from x in context.Training_Module where x.moduleId == item select x.moduleName).FirstOrDefault(); var getCompleted = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress == 100 select x).Count(); var getInProgress = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress > 0 && x.progress < 100 select x).Count(); var getNotStarted = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress == 0 select x).Count(); chart1.Series["Completed"].Points.AddXY(getModuleName, getCompleted); chart1.Series["In Progress"].Points.AddXY(getModuleName, getInProgress); chart1.Series["Not Started"].Points.AddXY(getModuleName, getNotStarted); } } }
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; } }
private void LoadData() { dataGridView1.Rows.Clear(); using (var context = new Session4Entities()) { var getUserID = (from x in context.Users where x.name == cbExpertName.SelectedItem.ToString() select x.userId).FirstOrDefault(); var getAssigned = (from x in context.Assign_Training where x.userIdFK == getUserID select x); if (rbName.Checked) { var orderedList = getAssigned.OrderBy(x => x.Training_Module.moduleName); foreach (var item in orderedList) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else if (rbProgress.Checked) { var orderedList = getAssigned.OrderByDescending(x => x.progress); foreach (var item in orderedList) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else { foreach (var item in getAssigned) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } foreach (DataGridViewRow item in dataGridView1.Rows) { var getEndDate = Convert.ToDateTime(dataGridView1.Rows[item.Index].Cells[3].Value); if (DateTime.Now > getEndDate || (getEndDate - DateTime.Now).TotalDays <= 5) { dataGridView1.Rows[item.Index].DefaultCellStyle.BackColor = Color.Red; } else if ((getEndDate - DateTime.Now).TotalDays <= 14 && (getEndDate - DateTime.Now).TotalDays > 5) { dataGridView1.Rows[item.Index].DefaultCellStyle.BackColor = Color.Yellow; } } } }
private void LoadData() { using (var context = new Session4Entities()) { var getSkillID = (from x in context.Skills where x.skillName == cbSkill.SelectedItem.ToString() select x.skillId).FirstOrDefault(); var getAssignedTraining = (from x in context.Assign_Training select x).ToList(); var competitorRow = new List <string>() { "Competitor" }; var expertRow = new List <string>() { "Expert" }; var expertCompleted = new List <string>() { "Completed" }; var expertInProcess = new List <string>() { "In Process" }; var expertNotStarted = new List <string>() { "Not Started" }; var competitorCompleted = new List <string>() { "Completed" }; var competitorInProcess = new List <string>() { "In Process" }; var competitorNotStarted = new List <string>() { "Not Started" }; var getDistinctMonths = (from x in getAssignedTraining where x.User.skillIdFK == getSkillID orderby x.startDate select x.startDate.ToString("MM/yyyy")).Distinct(); var getDistinctExpertModule = (from x in getAssignedTraining where x.User.skillIdFK == getSkillID where x.User.userTypeIdFK == 2 select x.moduleIdFK).Distinct(); var getDistinctCompetitorModule = (from x in getAssignedTraining where x.User.skillIdFK == getSkillID where x.User.userTypeIdFK == 3 select x.moduleIdFK).Distinct(); dataGridView1.ColumnCount = getDistinctMonths.Count() + 1; expertProgress.ColumnCount = getDistinctExpertModule.Count() + 1; competitorProgress.ColumnCount = getDistinctCompetitorModule.Count() + 1; dataGridView1.Columns[0].HeaderText = "Trainee Category"; expertProgress.Columns[0].HeaderText = "Status (Expert)"; competitorProgress.Columns[0].HeaderText = "Status (Competitor)"; int i = 1; int ie = 1; int ic = 1; foreach (var item in getDistinctMonths) { dataGridView1.Columns[i].HeaderText = $"No. Of Modules Start in {item}"; var getCountExpert = (from x in getAssignedTraining where x.User.userTypeIdFK == 2 && x.startDate.ToString("MM/yyyy") == item && x.User.skillIdFK == getSkillID select x.Training_Module).Distinct().Count(); expertRow.Add(getCountExpert.ToString()); var getCountCompetitors = (from x in getAssignedTraining where x.User.userTypeIdFK == 3 && x.startDate.ToString("MM/yyyy") == item && x.User.skillIdFK == getSkillID select x.Training_Module).Distinct().Count(); competitorRow.Add(getCountCompetitors.ToString()); i += 1; } foreach (var item in getDistinctExpertModule) { var getModuleName = (from x in context.Training_Module where x.moduleId == item select x.moduleName).FirstOrDefault(); var getCompleted = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress == 100 select x).Count(); var getInProgress = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress > 0 && x.progress < 100 select x).Count(); var getNotStarted = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress == 0 select x).Count(); expertProgress.Columns[ie].HeaderText = getModuleName; expertCompleted.Add(getCompleted.ToString()); expertInProcess.Add(getInProgress.ToString()); expertNotStarted.Add(getNotStarted.ToString()); ie += 1; } foreach (var item in getDistinctCompetitorModule) { var getModuleName = (from x in context.Training_Module where x.moduleId == item select x.moduleName).FirstOrDefault(); var getCompleted = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress == 100 select x).Count(); var getInProgress = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress > 0 && x.progress < 100 select x).Count(); var getNotStarted = (from x in context.Assign_Training where x.moduleIdFK == item && x.progress == 0 select x).Count(); competitorProgress.Columns[ic].HeaderText = getModuleName; competitorCompleted.Add(getCompleted.ToString()); competitorInProcess.Add(getInProgress.ToString()); competitorNotStarted.Add(getNotStarted.ToString()); ic += 1; } dataGridView1.Rows.Add(competitorRow.ToArray()); dataGridView1.Rows.Add(expertRow.ToArray()); expertProgress.Rows.Add(expertCompleted.ToArray()); expertProgress.Rows.Add(expertInProcess.ToArray()); expertProgress.Rows.Add(expertNotStarted.ToArray()); competitorProgress.Rows.Add(competitorCompleted.ToArray()); competitorProgress.Rows.Add(competitorInProcess.ToArray()); competitorProgress.Rows.Add(competitorNotStarted.ToArray()); } }
private void cbProgress_SelectedIndexChanged(object sender, EventArgs e) { using (var context = new Session4Entities()) { dataGridView1.Rows.Clear(); var userID = (from x in context.Users where x.name == cbCompetitorName.SelectedItem.ToString() select x.userId).FirstOrDefault(); if (cbProgress.SelectedItem.ToString() == "No Filter") { if (rbName.Checked) { LoadData(1); } else if (rbEndDate.Checked) { LoadData(2); } else { LoadData(0); } } else if (cbProgress.SelectedItem.ToString() == "Completed") { if (rbName.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.progress == 100 orderby x.Training_Module.moduleName select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else if (rbEndDate.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.progress == 100 select x).ToList(); var getOrdered = (from x in getAssignedModules orderby x.startDate.AddDays(x.Training_Module.durationDays) descending select x); foreach (var item in getOrdered) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.progress == 100 select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } } else if (cbProgress.SelectedItem.ToString() == "In Progress") { if (rbName.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID where x.progress > 0 && x.progress < 100 orderby x.Training_Module.moduleName select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else if (rbEndDate.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID where x.progress > 0 && x.progress < 100 select x).ToList(); var getOrdered = (from x in getAssignedModules orderby x.startDate.AddDays(x.Training_Module.durationDays) descending select x); foreach (var item in getOrdered) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID where x.progress > 0 && x.progress < 100 select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } } else { if (rbName.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.progress == 0 orderby x.Training_Module.moduleName select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else if (rbEndDate.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.progress == 0 select x).ToList(); var getOrdered = (from x in getAssignedModules orderby x.startDate.AddDays(x.Training_Module.durationDays) descending select x); foreach (var item in getOrdered) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.progress == 0 select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } } } }
private void txtSearch_TextChanged(object sender, EventArgs e) { dataGridView1.Rows.Clear(); if (string.IsNullOrWhiteSpace(txtSearch.Text)) { if (rbName.Checked) { LoadData(1); } else if (rbEndDate.Checked) { LoadData(2); } else { LoadData(0); } } else { using (var context = new Session4Entities()) { var userID = (from x in context.Users where x.name == cbCompetitorName.SelectedItem.ToString() select x.userId).FirstOrDefault(); if (rbName.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.Training_Module.moduleName.ToLower().Contains(txtSearch.Text.ToLower()) orderby x.Training_Module.moduleName select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else if (rbEndDate.Checked) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.Training_Module.moduleName.ToLower().Contains(txtSearch.Text.ToLower()) select x).ToList(); var getOrdered = (from x in getAssignedModules orderby x.startDate.AddDays(x.Training_Module.durationDays) descending select x); foreach (var item in getOrdered) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID && x.Training_Module.moduleName.ToLower().Contains(txtSearch.Text.ToLower()) select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } } } }
private void LoadData(int mode) { dataGridView1.Rows.Clear(); using (var context = new Session4Entities()) { var userID = (from x in context.Users where x.name == cbCompetitorName.SelectedItem.ToString() select x.userId).FirstOrDefault(); if (mode == 0) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else if (mode == 1) { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID orderby x.Training_Module.moduleName select x); foreach (var item in getAssignedModules) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } else { var getAssignedModules = (from x in context.Assign_Training where x.User.userId == userID select x).ToList(); var getOrdered = (from x in getAssignedModules orderby x.startDate.AddDays(x.Training_Module.durationDays) descending select x); foreach (var item in getOrdered) { var newRow = new List <string>() { item.Training_Module.moduleName, item.Training_Module.durationDays.ToString(), item.startDate.ToShortDateString(), item.startDate.AddDays(item.Training_Module.durationDays).ToShortDateString(), item.progress.ToString(), item.trainingId.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } } }