private void SaveWorkExp() { try { foreach (var xe in db.t_TempEmpWorkExp.Where(p => p.EmpID == adminusers.Text)) { compName2 = xe.CompanyName; compAddress2 = xe.CompanyAddress; compPosition2 = xe.Position; compFrom2 = Convert.ToString(xe.DateFrom); compTo2 = Convert.ToString(xe.DateTo); var newexp = new t_EmpWorkExperience(); newexp.EmpID = NewEmpID; newexp.CompanyName = compName2; newexp.CompanyAddress = compAddress2; newexp.Position = compPosition2; newexp.DateFrom = Convert.ToDateTime(compFrom2); newexp.DateTo = Convert.ToDateTime(compTo2);; newexp.LastUpdate = DateTime.Now; db.t_EmpWorkExperience.Add(newexp); } db.SaveChanges(); removeTempExperience(); } catch { } }
private void gridWorkExp_AddingNewDataItem(object sender, Telerik.Windows.Controls.GridView.GridViewAddingNewEventArgs e) { try { var work = new t_EmpWorkExperience(); work.EmpID = EmpID.Text; work.CompanyName = compName; work.CompanyAddress = compAddress; work.DateFrom = Convert.ToDateTime(compFrom);; work.DateTo = Convert.ToDateTime(compTo);; work.Position = compPosition; work.LastUpdate = DateTime.Now; e.NewObject = work; db.t_EmpWorkExperience.Add(work); } catch { } }
private void gridWorkExp_RowEditEnded(object sender, Telerik.Windows.Controls.GridViewRowEditEndedEventArgs e) { if (e.EditAction == GridViewEditAction.Cancel) { return; } if (e.EditOperationType == GridViewEditOperationType.Insert) { try { db.SaveChanges(); bindWorkExp(); } catch { } } else if (e.EditOperationType == GridViewEditOperationType.Edit) { try { foreach (var data in gridWorkExp.SelectedItems) { t_EmpWorkExperience myData = data as t_EmpWorkExperience; compName = myData.CompanyName; compAddress = myData.CompanyAddress; compPosition = myData.Position; compFrom = Convert.ToString(myData.DateFrom); compTo = Convert.ToString(myData.DateTo); } //t_EmpWorkExperience workexp = db.t_EmpWorkExperience.First(p => p.EmpID == EmpID.Text); var workexp = db.t_EmpWorkExperience.Where(p => p.EmpID == EmpID.Text).Where(x => x.CompanyName == compName).FirstOrDefault(); //workexp.CompanyName = compName; workexp.CompanyAddress = compAddress; workexp.Position = compPosition; workexp.DateFrom = Convert.ToDateTime(compFrom); workexp.DateTo = Convert.ToDateTime(compTo); db.Entry(workexp).State = EntityState.Modified; db.SaveChanges(); bindWorkExp(); } catch { } } }
private void gridWorkExp_PreviewKeyDown(object sender, KeyEventArgs e) { try { if (e.Key == Key.Delete) { foreach (var data in gridWorkExp.SelectedItems) { t_EmpWorkExperience myData = data as t_EmpWorkExperience; var delete = db.t_EmpWorkExperience.Where(p => p.EmpID == EmpID.Text && p.CompanyName == myData.CompanyName).FirstOrDefault(); db.t_EmpWorkExperience.Remove(delete); db.SaveChanges(); } bindWorkExp(); } else { return; } } catch { } }