public PODETAIL Get(String PONO)
{
using (PODbEntities db = new PODbEntities())
{
return(db.PODETAILs.SingleOrDefault(m => m.PONO == PONO));
}
}
public ITEM Get(String ITCODE)
{
using (PODbEntities db = new PODbEntities())
{
return(db.ITEMs.Find(ITCODE));
}
}
public SUPPLIER Get(String SUPLNO)
{
using (PODbEntities db = new PODbEntities())
{
return(db.SUPPLIERs.Find(SUPLNO));
}
}
public IEnumerable <PODETAIL> Get()
{
using (PODbEntities db = new PODbEntities())
{
return(db.PODETAILs.ToList());
}
}
public POMASTER Get(String PONO)
{
using (PODbEntities db = new PODbEntities())
{
return(db.POMASTERs.Find(PONO));
}
}
public IEnumerable <POMASTER> Get()
{
using (PODbEntities db = new PODbEntities())
{
return(db.POMASTERs.ToList());
}
}
public IEnumerable <SUPPLIER> Get()
{
using (PODbEntities db = new PODbEntities())
{
return(db.SUPPLIERs.ToList());
}
}
public IEnumerable <ITEM> Get()
{
using (PODbEntities db = new PODbEntities())
{
return(db.ITEMs.ToList());
}
}
public void Delete(String PONO)
{
using (PODbEntities db = new PODbEntities())
{
db.PODETAILs.Remove(db.PODETAILs.SingleOrDefault(m => m.PONO == PONO));
db.SaveChanges();
}
}
public void Delete(String PONO)
{
using (PODbEntities db = new PODbEntities())
{
db.POMASTERs.Remove(db.POMASTERs.Find(PONO));
db.SaveChanges();
}
}
public void Delete(String ITCODE)
{
using (PODbEntities db = new PODbEntities())
{
db.ITEMs.Remove(db.ITEMs.Find(ITCODE));
db.SaveChanges();
}
}
public void Post([FromBody] ITEM item)
{
using (PODbEntities db = new PODbEntities())
{
db.ITEMs.Add(item);
db.SaveChanges();
}
}
public void Post([FromBody] PODETAIL item)
{
using (PODbEntities db = new PODbEntities())
{
db.PODETAILs.Add(item);
db.SaveChanges();
}
}
public void Delete(String SUPLNO)
{
using (PODbEntities db = new PODbEntities())
{
db.SUPPLIERs.Remove(db.SUPPLIERs.Find(SUPLNO));
db.SaveChanges();
}
}
public void Put([FromBody] SUPPLIER item)
{
using (PODbEntities db = new PODbEntities())
{
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Post([FromBody] SUPPLIER item)
{
using (PODbEntities db = new PODbEntities())
{
db.SUPPLIERs.Add(item);
db.SaveChanges();
}
}
public SupplierRepository(PODbEntities context)
{
_context = context;
}
public PoMasterRepository(PODbEntities context)
{
_context = context;
}
public PoDetailRepository(PODbEntities context)
{
_context = context;
}
public ItemRepository(PODbEntities context)
{
_context = context;
}
