/// <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();
}
}
public void DeleteBankAccount(int id)
{
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
PersonBankAccount obj = db.PersonBankAccounts.Find(id);
db.PersonBankAccounts.Remove(obj);
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>
/// 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>
/// Return Person User Foreign Key to Display it as DropdownList in each method contain in PersonController
/// </summary>
/// <returns></returns>
public List<int?> GetPersonFK()
{
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
List<int?> ls = new List<int?>();
ls = db.People.Include("SSUser").Select(b => b.PersonUserFK).ToList();
return ls;
}
}
/// <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 DataTable getBankAccounts()
{
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
List<PersonBankAccount> ls = db.PersonBankAccounts.Include("Person").ToList();
DataTable table = ls.ToDataTable<PersonBankAccount>();
return table;
}
}
public DataRow GetBankAccount(int id)
{
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
PersonBankAccount obj = db.PersonBankAccounts.Find(id);
DataRow row = obj.ToDataRow();
return row;
}
}
public void EditBankAccount(DataRow row)
{
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
PersonBankAccount obj = row.GetItem<PersonBankAccount>();
db.Entry(obj).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();
}
}
public void AddPersonBankAccount(DataRow row)
{
PersonBankAccount obj = row.GetItem<PersonBankAccount>();
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
db.PersonBankAccounts.Add(obj);
db.SaveChanges();
}
}
/// <summary>
/// retun SSUser Detail information
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataRow GetSSUser(int id)
{
using (var db = new EnterpriceDBEntities())
{
SSUser usr = new SSUser();
usr = db.SSUsers.Include("Persons").Include("SSUserRoles").Single(b=>b.UsrPK == id);
DataRow row = usr.ToDataRow<SSUser>();
return row;
}
}
/// <summary>
/// Cebes-Get person detail by person ID
/// </summary>
/// <param name="id">Person ID to be searched</param>
/// <returns></returns>
public DataRow GetPerson(int id)
{
Person pers = new Person();
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
pers = db.People.Find(id);
//pers = db.Persons.Include("SSUser").Single(b => b.PersonPK == id);
}
DataRow row = pers.ToDataRow<Person>();
return row;
}
/// <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();
}
}
}
/// <summary>
/// GetIndex return all of the data contain in the person table as list
/// </summary>
/// <returns></returns>
public DataTable GetPersons()
{
using (EnterpriceDBEntities db = new EnterpriceDBEntities())
{
List<Person> ls = new List<Person>();
//ls = db.Persons.Include("SSUser").ToList();
ls = db.People.ToList();
return ls.ToDataTable<Person>();
}
}
/// <summary>
/// Searching User Based on ID
/// </summary>
/// <param name="clue"></param>
/// <returns></returns>
public DataTable searchUser(string clue)
{
using (var db = new EnterpriceDBEntities())
{
var ssuser = from q in db.SSUsers
select q;
ssuser = ssuser.Where(s => s.UsrID.Contains(clue));
List<SSUser> ls = ssuser.ToList();
DataTable table = ls.ToDataTable<SSUser>();
return table;
}
}
/// <summary>
/// Return SSUser IndexE:\Schools Stuff\PT Cebes\Enterprice\BusinessObject\Class\SSUser.cs
/// </summary>
/// <returns></returns>
public DataTable GetSSUsers()
{
//var ssuser = lazySSUser.Value;
List<SSUser> list = new List<SSUser>();
using (var db = new EnterpriceDBEntities())
{
list = db.SSUsers.Include("Persons").Include("SSUserRoles").ToList();
DataTable table = list.ToDataTable<SSUser>();
return table;
}
}
/// <summary>
/// Search Person Based on PersonName
/// </summary>
/// <param name="searchString"></param>
/// <returns></returns>
public DataTable searchPerson(string searchString)
{
using (var db = new EnterpriceDBEntities())
{
var x = from m in db.People
select m;
x = x.Where(s => s.PersonName.Contains(searchString));
List<Person> ls = x.ToList();
DataTable table = ls.ToDataTable<Person>();
return table;
}
}
