private void saveDeveloper(int id)
{
//Update developer basic details
DevDetail dev = easyContext.DevDetails.Where(a => a.Id == id).FirstOrDefault();
dev.FullName = txtName.Value;
dev.LinkedIn = txtLinkedIn.Value;
dev.Skype = txtSkype.Value;
dev.Email = txtEmail.Value;
dev.Salary = Convert.ToDecimal(txtSalary.Value);
dev.City = txtCity.Value;
dev.Portfolio = txtPortfolio.Value;
dev.Phone = txtPhone.Value;
dev.State = txtState.Value;
easyContext.SaveChanges();
//Remove Saved Settings
var oldDaytime = easyContext.DevDayTimes.Where(a => a.DevId == id);
easyContext.DevDayTimes.RemoveRange(oldDaytime);
var oldHours = easyContext.DevHours.Where(a => a.DevId == id);
easyContext.DevHours.RemoveRange(oldHours);
easyContext.SaveChanges();
//Update hour preferences
var checkedHours = chkHours.Items.Cast <ListItem>().Where(x => x.Selected);
foreach (var hour in checkedHours)
{
DevHour hours = new DevHour();
hours.DevId = id;
hours.HourId = Convert.ToInt32(hour.Value);
easyContext.DevHours.Add(hours);
}
easyContext.SaveChanges();
//Update daytime preferences
var checkedDayTime = chkDayTime.Items.Cast <ListItem>().Where(x => x.Selected);
foreach (var item in checkedDayTime)
{
DevDayTime devDay = new DevDayTime();
devDay.DevId = id;
devDay.DayTimeId = Convert.ToInt32(item.Value);
easyContext.DevDayTimes.Add(devDay);
}
easyContext.SaveChanges();
//Update Skills
foreach (var item in DevSkillsApplied)
{
DevSkill skill = easyContext.DevSkills.Where(a => a.DevId == id).FirstOrDefault();
skill.Rating = item.Rating;
easyContext.SaveChanges();
}
var savedDev = easyContext.DevDetails.Where(a => a.Id == id).FirstOrDefault();
ShowMessage("Successfully Updated - " + savedDev.FullName + " Details", WarningType.Success);
}
private void saveDeveloper()
{
//Save developer basic details
DevDetail dev = new DevDetail();
dev.FullName = txtName.Value;
dev.LinkedIn = txtLinkedIn.Value;
dev.Skype = txtSkype.Value;
dev.Email = txtEmail.Value;
dev.Salary = Convert.ToDecimal(txtSalary.Value);
dev.City = txtCity.Value;
dev.Portfolio = txtPortfolio.Value;
dev.Phone = txtPhone.Value;
dev.State = txtState.Value;
easyContext.DevDetails.Add(dev);
easyContext.SaveChanges();
var savedDev = easyContext.DevDetails.Where(a => a.Email == dev.Email && a.FullName == dev.FullName).OrderByDescending(a => a.Id).FirstOrDefault();
//Save hour preferences
var checkedHours = chkHours.Items.Cast <ListItem>().Where(x => x.Selected);
foreach (var hour in checkedHours)
{
DevHour hours = new DevHour();
hours.DevId = savedDev.Id;
hours.HourId = Convert.ToInt32(hour.Value);
easyContext.DevHours.Add(hours);
}
easyContext.SaveChanges();
//Save daytime preferences
var checkedDayTime = chkDayTime.Items.Cast <ListItem>().Where(x => x.Selected);
foreach (var item in checkedDayTime)
{
DevDayTime devDay = new DevDayTime();
devDay.DevId = savedDev.Id;
devDay.DayTimeId = Convert.ToInt32(item.Value);
easyContext.DevDayTimes.Add(devDay);
}
easyContext.SaveChanges();
foreach (var item in DevSkillsApplied)
{
DevSkill skill = new DevSkill();
skill.DevId = savedDev.Id;
skill.SkillId = item.SkillId;
skill.Rating = item.Rating;
easyContext.DevSkills.Add(skill);
}
easyContext.SaveChanges();
ShowMessage("Successfully added Developer - " + savedDev.FullName, WarningType.Success);
}
