public List <permohonan> GetAllPermohonan(bidang bidangTugas)
{
try
{
using (var db = new OcphDbContext())
{
var list = new List <permohonan>();
var permohonans = (from a in db.Tahapans.Where(O => O.BidangId == bidangTugas.Id)
join b in db.TahapanLayanan.Select() on a.Id equals b.TahapanId
join c in db.Layanans.Select() on b.Id equals c.Id
join d in db.Permohonans.Select() on c.Id equals d.IdLayanan
join f in db.Pemohons.Select() on d.IdPemohon equals f.Id
select new permohonan {
Id = d.Id, IdLayanan = d.IdLayanan, IdPemohon = d.IdPemohon, Status = d.Status, Layanan = c, Pemohon = f
}).ToList();
var resutl = permohonans.GroupBy(O => O.Id);
foreach (var item in resutl)
{
var a = item.FirstOrDefault();
list.Add(a);
}
return(list);
}
}
catch (Exception)
{
return(new List <permohonan>());
}
}
// PUT: api/Pegawai/5
public HttpResponseMessage Put(int id, [FromBody] bidang value)
{
try
{
if (ModelState.IsValid)
{
using (var db = new OcphDbContext())
{
var isUpdate = db.Bidang.Update(O => new { O.Keterangan, O.Nama }, value, O => O.Id == value.Id);
if (isUpdate)
{
return(Request.CreateResponse(HttpStatusCode.OK, value));
}
else
{
throw new SystemException("Data tidak tersimpan");
}
}
}
else
{
throw new SystemException("Data Tidak Valid");
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotModified, ex.Message));
}
}
public bidang SaveChange(bidang item)
{
using (var db = new OcphDbContext())
{
try
{
if (item.Id <= 0)
{
item.Id = db.Bidangs.InsertAndGetLastID(item);
if (item.Id <= 0)
{
throw new SystemException("Data tidak tersimpan");
}
}
else
{
if (!db.Bidangs.Update(O => new { O.Nama, O.PetugasId, O.Descripsi }, item, O => O.Id == item.Id))
{
throw new SystemException("Data Tidak Tersimpan");
}
}
return(item);
}
catch (Exception ex)
{
throw new SystemException(ex.Message);
}
}
}
// POST: api/Pegawai
public HttpResponseMessage Post([FromBody] bidang value)
{
try
{
if (ModelState.IsValid)
{
using (var db = new OcphDbContext())
{
value.Id = db.Bidang.InsertAndGetLastID(value);
if (value.Id > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, value));
}
else
{
throw new SystemException("Data tidak tersimpan");
}
}
}
else
{
throw new SystemException("Data Tidak Valid");
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotModified, ex.Message));
}
}
public IActionResult Put(int id, [FromBody] bidang value)
{
try
{
bidang results = service.SaveChange(value);
return(Ok(results));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
private void SaveCommandAction(object obj)
{
var main = ResourcesBase.GetMainWindowViewModel();
bidang item = new bidang {
Id = this.Id, Keterangan = this.Keterangan, Nama = Nama
};
if (this.Id <= 0)
{
main.BidangCollection.Add(item);
}
else
{
main.BidangCollection.Updated(item);
}
this.WindowClose();
}
public List <tahapan> GetTahapanTugasBidang(bidang bidangTugas)
{
throw new NotImplementedException();
}
public AddNewBidangViewModel(bidang selectedItem)
{
this.Title = "Edit Bidang";
this.selectedItem = selectedItem;
}
public void SetBidangTugas(bidang bidang)
{
BidangTugas = bidang;
}
