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