private void SaveDependents() { try { foreach (var xe in db.t_TempEmpDependents.Where(p => p.EmpID == adminusers.Text)) { depName2 = xe.Name; depBirthDate2 = Convert.ToString(xe.BirthDate); depRelationship2 = xe.Relationship; depOccupation2 = xe.Occupation; depMaidenName2 = xe.MaidenName; var newdep = new t_EmpDependents(); newdep.EmpID = NewEmpID; newdep.Name = depName2; newdep.BirthDate = Convert.ToDateTime(depBirthDate2); newdep.Relationship = depRelationship2; newdep.Occupation = depOccupation2; newdep.MaidenName = depMaidenName2; newdep.LastUpdate = DateTime.Now; db.t_EmpDependents.Add(newdep); } db.SaveChanges(); removeTempDependents(); } catch { } }
private void gridDependent_RowEditEnded(object sender, GridViewRowEditEndedEventArgs e) { if (e.EditAction == GridViewEditAction.Cancel) { return; } if (e.EditOperationType == GridViewEditOperationType.Insert) { try { db.SaveChanges(); bindDependents(); } catch { } } else if (e.EditOperationType == GridViewEditOperationType.Edit) { // try //{ int ss = 0; foreach (var data in gridDependent.SelectedItems) { t_EmpDependents myData = data as t_EmpDependents; depName = myData.Name; depBirthDate = Convert.ToString(myData.BirthDate); depRelationship = myData.Relationship; depOccupation = myData.Occupation; depMaidenName = myData.MaidenName; ss = Convert.ToInt32(myData.DependentID); } var dep = db.t_EmpDependents.Where(x => x.DependentID == ss).FirstOrDefault(); dep.BirthDate = Convert.ToDateTime(depBirthDate); dep.Relationship = depRelationship; dep.Occupation = depOccupation; dep.MaidenName = depMaidenName; db.Entry(dep).State = EntityState.Modified; db.SaveChanges(); bindDependents(); // } //catch { } } }
private void gridDependent_AddingNewDataItem(object sender, Telerik.Windows.Controls.GridView.GridViewAddingNewEventArgs e) { try { var depen = new t_EmpDependents(); depen.EmpID = EmpID.Text; depen.Name = depName; depen.BirthDate = Convert.ToDateTime(depBirthDate); depen.Relationship = depRelationship; depen.Occupation = depOccupation; depen.MaidenName = depMaidenName; depen.LastUpdate = DateTime.Now; e.NewObject = depen; db.t_EmpDependents.Add(depen); } catch { } }
private void gridDependent_PreviewKeyDown(object sender, KeyEventArgs e) { try { if (e.Key == Key.Delete) { foreach (var data in gridDependent.SelectedItems) { t_EmpDependents myData = data as t_EmpDependents; var delete = db.t_EmpDependents.Where(p => p.EmpID == EmpID.Text && p.Name == myData.Name).FirstOrDefault(); db.t_EmpDependents.Remove(delete); db.SaveChanges(); } } else { return; } } catch { } }