public IQueryable <LegalPerson> GetLPPeople()
{
var _db = new ContragentContext();
IQueryable <LegalPerson> query = _db.LegalPeople;
return(query);
}
public IQueryable <PhysPerson> GetSPPeople([QueryString("searchString")] string searchString)
{
var _db = new ContragentContext();
IQueryable <PhysPerson> query = _db.PhysPeople;
query = query.Where(s => s.Iin_bin.Contains(searchString));
return(query);
}
public IQueryable <PhysPerson> legalContact_GetData([QueryString] int?legPersonID)
{
var _db = new ContragentContext();
IQueryable <PhysPerson> query = _db.PhysPeople;
if (legPersonID.HasValue && legPersonID > 0)
{
query = query.Where(p => p.LegPersonID == legPersonID);
}
return(query);
}
public void addPersonForm_InsertItem()
{
var item = new PhysPerson();
TryUpdateModel(item);
if (ModelState.IsValid)
{
using (ContragentContext db = new ContragentContext())
{
item.CreateDate = new DateTimeOffset(DateTime.Now);
db.PhysPeople.Add(item);
db.SaveChanges();
}
}
}
public IQueryable <PhysPerson> GetPDPeople([QueryString("physPersonId")] int?physPersonId)
{
var _db = new ContragentContext();
IQueryable <PhysPerson> query = _db.PhysPeople;
if (physPersonId.HasValue && physPersonId > 0)
{
query = query.Where(p => p.ID == physPersonId);
}
else
{
query = null;
}
return(query);
}
public IQueryable <LegalPerson> GetLDPeople([QueryString("legPersonId")] int?legPersonId)
{
var _db = new ContragentContext();
IQueryable <LegalPerson> query = _db.LegalPeople;
if (legPersonId.HasValue && legPersonId > 0)
{
query = query.Where(p => p.ID == legPersonId);
}
else
{
query = null;
}
return(query);
}
public void delete_leg_person([QueryString("legPersonId")] int legPersonId)
{
using (ContragentContext db = new ContragentContext())
{
var item = new LegalPerson {
ID = legPersonId
};
db.Entry(item).State = EntityState.Deleted;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Item with id {0} no longer exists in the database.", legPersonId));
}
}
}
public void physpeople_UpdateItem([QueryString("physPersonID")] int personID)
{
using (ContragentContext db = new ContragentContext())
{
PhysPerson item = null;
item = db.PhysPeople.Find(personID);
if (item == null)
{
ModelState.AddModelError("",
String.Format("Item with id {0} was not found", personID));
return;
}
item.UpdateDate = new DateTimeOffset(DateTime.Now);
TryUpdateModel(item);
if (ModelState.IsValid)
{
db.SaveChanges();
}
}
Response.Redirect("~/PeopleList");
}
