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