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