public Task <agents> GetById(int id)
{
using (var db = new InccomingDbContext())
{
var result = db.Agents.Where(O => O.Id == id).FirstOrDefault();
return(Task.FromResult(result));
}
}
public Task <List <agents> > Get()
{
using (var db = new InccomingDbContext())
{
var result = db.Agents.Select().ToList();
return(Task.FromResult(result));
}
}
public Task <List <manifestsincomming> > Get()
{
using (var db = new InccomingDbContext())
{
var result = db.Manifests.Select().ToList();
return(Task.FromResult(result));
}
}
public Task <agents> Put(agents agent)
{
using (var db = new InccomingDbContext())
{
var isUpdated = db.Agents.Update(O => new { O.Address, O.ContactPerson, O.Name, O.Telepon }, agent, O => O.Id == agent.Id);
if (isUpdated)
{
return(Task.FromResult(agent));
}
else
{
throw new SystemException("Data Tidak Berhasil Diubah");
}
}
}
public Task <agents> Post(agents agent)
{
using (var db = new InccomingDbContext())
{
agent.Id = db.Agents.InsertAndGetLastID(agent);
if (agent.Id > 0)
{
return(Task.FromResult(agent));
}
else
{
throw new SystemException("Data Tidak Terhapus");
}
}
}
public Task <manifestsincomming> Put(manifestsincomming item)
{
using (var db = new InccomingDbContext())
{
var isUpdated = db.Manifests.Update(O => new { O.ManifestNumber, O.UpdateDate, O.UserId, O.Via }, item, O => O.Id == item.Id);
if (isUpdated)
{
return(Task.FromResult(item));
}
else
{
throw new SystemException("Data Tidak Berhasil Diubah");
}
}
}
public Task <manifestsincomming> Post(manifestsincomming item)
{
using (var db = new InccomingDbContext())
{
item.Id = db.Manifests.InsertAndGetLastID(item);
if (item.Id > 0)
{
return(Task.FromResult(item));
}
else
{
throw new SystemException("Data Tidak Terhapus");
}
}
}
