/// <summary> /// Delete an existing person identity /// </summary> /// <param name="id"></param> public void DeletePerson(int id) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()){ Person pers = db.People.Find(id); db.People.Remove(pers); db.SaveChanges(); } }
/// <summary> /// Update and edit existing person identity /// </summary> /// <param name="person"></param> public void EditPerson(DataRow row) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { Person person = row.GetItem<Person>(); db.Entry(person).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// Deleted User based on SSUser ID /// </summary> /// <param name="id"></param> public void DeleteSSUser(int id) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { SSUser s = db.SSUsers.Find(id); db.SSUsers.Remove(s); db.SaveChanges(); } }
/// <summary> /// Set or Add new person /// </summary> /// <param name="person"></param> public void AddPerson(DataRow row) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { Person person = row.GetItem<Person>(); db.People.Add(person); db.SaveChanges(); } }
/// <summary> /// Add New User /// </summary> /// <param name="user"></param> public void AddNewUser(DataRow row) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { SSUser user = row.GetItem<SSUser>(); db.SSUsers.Add(user); db.SaveChanges(); } }
public void EditBankAccount(DataRow row) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { PersonBankAccount obj = row.GetItem<PersonBankAccount>(); db.Entry(obj).State = EntityState.Modified; db.SaveChanges(); } }
public void DeleteBankAccount(int id) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { PersonBankAccount obj = db.PersonBankAccounts.Find(id); db.PersonBankAccounts.Remove(obj); db.SaveChanges(); } }
public void AddPersonBankAccount(DataRow row) { PersonBankAccount obj = row.GetItem<PersonBankAccount>(); using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { db.PersonBankAccounts.Add(obj); db.SaveChanges(); } }
/// <summary> /// Saving the editted user into database /// </summary> /// <param name="us"></param> public void EditSSUser(DataRow row) { using (EnterpriceDBEntities db = new EnterpriceDBEntities()) { try { SSUser us = row.GetItem<SSUser>(); db.Entry(us).State = EntityState.Modified; db.SaveChanges(); } catch (OptimisticConcurrencyException) { //db.SaveChanges(); } } }