public IActionResult Post([FromBody] Profile model)
{
model.CreateDate = DateTime.Now;
model.UpdateDate = model.CreateDate;
try {
using (var db = new OcphDbContext()) {
var saved = db.Profiles.InsertAndGetLastID(model);
return(Ok(saved));
}
} catch (System.Exception ex) {
return(BadRequest(ex));
}
}
internal ObservableCollection <PelunasanPiutang> GetPelunasanUtang()
{
var list = new ObservableCollection <PelunasanPiutang>();
using (var db = new OcphDbContext())
{
var datas = from pelunasan in db.PelunasanPiutang.Select()
join transaksi in db.Penjualans.Select() on pelunasan.PenjualanId equals transaksi.PenjualanId
join customer in db.Customers.Select() on transaksi.CustomerId equals customer.CustomerId
select new PelunasanPiutang
{
Tanggal = transaksi.Tanggal,
Bayar = pelunasan.Bayar,
PelunasanPiutangId = pelunasan.PelunasanPiutangId,
TanggalBayar = pelunasan.TanggalBayar,
JatuhTempo = transaksi.JatuhTempo,
NomorFaktur = transaksi.NomorFaktur,
Pelunasan = transaksi.Pelunasan,
Pembayaran = transaksi.Pembayaran,
PenjualanId = transaksi.PenjualanId,
UserId = transaksi.UserId,
Customer = Mapper.Map <Customer>(customer),
};
foreach (var item in datas)
{
var details = (from detail in db.DetailPenjualan.Where(x => x.PenjualanId == item.PenjualanId)
join barang in db.Barangs.Select() on detail.BarangId equals barang.BarangId
select new ItemPenjualan
{
KodeBarang = barang.KodeBarang,
DetailPenjualanId = detail.DetailPenjualanId,
PenjualanId = detail.PenjualanId,
HargaBeli = barang.HargaBeli,
HargaJual = barang.HargaJual,
Jumlah = detail.Jumlah,
Merk = barang.Merk,
Satuan = barang.Satuan,
NamaBarang = barang.NamaBarang,
BarangId = barang.BarangId
});
item.Details = new ObservableCollection <ItemPenjualan>(details);
list.Add(Mapper.Map <PelunasanPiutang>(item));
}
return(list);
}
}
public IActionResult Delete(int id)
{
using (var db = new OcphDbContext())
{
if (service.DeleteKategory(id))
{
return(Ok());
}
else
{
return(BadRequest());
}
}
}
public List <persyaratan> GetPersyaratans(layanan t)
{
if (t == null)
{
throw new ArgumentNullException("layanan", "Layanan IsNUll");
}
else
{
using (var db = new OcphDbContext())
{
return(db.Persyaratans.Where(O => O.IdLayanan == t.Id).ToList());
}
}
}
// GET: api/Pengaturan/5
public HttpResponseMessage Get(int id)
{
try
{
using (var db = new OcphDbContext())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.Setting.Where(O => O.Id == id).FirstOrDefault()));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
internal bool AddPembayaran(PelunasanPiutang pelunasan, StatusPelunasan statusPelunasan)
{
using (var db = new OcphDbContext())
{
var trans = db.BeginTransaction();
try
{
var dto = Mapper.Map <PelunasanPiutangDto>(pelunasan);
if (pelunasan.PelunasanPiutangId == null)
{
var id = db.PelunasanPiutang.InsertAndGetLastID(dto);
if (id > 0)
{
pelunasan.PelunasanPiutangId = id;
if (!db.Penjualans.Update(x => new { x.Pelunasan }, new PenjualanDto {
Pelunasan = statusPelunasan
},
x => x.PenjualanId == pelunasan.PenjualanId))
{
throw new SystemException("Pelunasan Utang Tidak Berhasil Disimpan");
}
}
}
else
{
var saved = db.PelunasanPiutang.Update(x => new { x.Bayar, x.TanggalBayar }, dto,
x => x.PelunasanPiutangId == pelunasan.PelunasanPiutangId);
if (saved)
{
if (!db.Penjualans.Update(x => new { x.Pelunasan }, new PenjualanDto {
Pelunasan = statusPelunasan
},
x => x.PenjualanId == pelunasan.PenjualanId))
{
throw new SystemException("Pelunasan Utang Tidak Berhasil Disimpan");
}
}
}
trans.Commit();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
throw new SystemException(ex.Message);
}
}
}
public persyaratan GetPersyartan(int Id)
{
if (Id <= 0)
{
throw new ArgumentException("Id", "Set Persyaratan Id");
}
else
{
using (var db = new OcphDbContext())
{
return(db.Persyaratans.Where(O => O.Id == Id).FirstOrDefault());
}
}
}
public int ManifestCount()
{
try
{
using (var db = new OcphDbContext())
{
return(db.Manifests.Where(O => O.AgentId == AgentId).Count());
}
}
catch (Exception)
{
return(0);
}
}
public bool DeletePersyaratan(int Id)
{
if (Id <= 0)
{
throw new ArgumentException("Pilih Kategori", "Id");
}
else
{
using (var db = new OcphDbContext())
{
return(db.Persyaratans.Delete(O => O.Id == Id));
}
}
}
public int InvoiceCount()
{
try
{
using (var db = new OcphDbContext())
{
return(db.Invoices.Select().Count());
}
}
catch (Exception)
{
return(0);
}
}
public int ManifestCount()
{
try
{
using (var db = new OcphDbContext())
{
return(db.Manifests.Select().Count());
}
}
catch (Exception)
{
return(0);
}
}
public async Task <bool> RoleExsistsAsync(string roleName)
{
bool exists = false;
using (var db = new OcphDbContext()) {
var result = db.Roles.Where(x => x.name == roleName).FirstOrDefault();
if (result != null)
{
exists = true;
}
}
return(await Task.FromResult(exists));
}
internal bool Save(Customer selected)
{
using (var db = new OcphDbContext())
{
try
{
var dto = Mapper.Map<CustomerDto>(selected);
if (selected.CustomerId == null)
{
var id = db.Customers.InsertAndGetLastID(dto);
if (id > 0)
{
selected.CustomerId = id;
Source.Add(selected);
return true;
}
}
else
{
var saved = db.Customers.Update(x => new { x.Alamat, x.KodeCustomer, x.NamaCustomer, x.NoTelepon,x.Status },
dto, x => x.CustomerId == dto.CustomerId);
if (saved)
{
var existData = Source.Where(x => x.CustomerId == selected.CustomerId).FirstOrDefault();
if (existData != null)
{
existData = Mapper.Map<Customer>(selected);
}
return true;
}
}
throw new SystemException("Data Tidak Tersimpan");
}
catch (Exception ex)
{
if (ex.Message == "Data Duplikat")
{
throw new SystemException($"Kode Customer {selected.KodeCustomer} Sudah Ada");
}
else
{
throw new SystemException(ex.Message);
}
}
}
}
private void SaveCommandAction(object obj)
{
using (var db = new OcphDbContext())
{
var trans = db.Connection.BeginTransaction();
try
{
if (Id == 0)
{
var saved = db.Periodes.Update(O => new { O.Aktif }, new periode {
Aktif = false
},
O => O.Aktif == true);
Id = db.Periodes.InsertAndGetLastID(this);
if (Id > 0)
{
MessageBox.Show("Data Berhasil Disimpan", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
IsSaved = true;
trans.Commit();
this.WindowClose();
}
else
{
MessageBox.Show("Data Tidak Tersimpan", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
var saved = db.Periodes.Update(O => new { O.KodePeriode, O.TanggalPengajuan, O.TanggalRencanaPengiriman }, this,
O => O.Id == this.Id);
if (saved)
{
MessageBox.Show("Data Berhasil Disimpan", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
IsSaved = true;
trans.Commit();
this.WindowClose();
}
else
{
MessageBox.Show("Data Tidak Tersimpan", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
catch (Exception ex)
{
trans.Rollback();
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
public List <tahapan> GetTahapans(layanan t)
{
using (var db = new OcphDbContext())
{
if (t == null)
{
throw new ArgumentNullException(t.GetType().Name, " IsNull");
}
else
{
return(db.Tahapans.Where(O => O.BidangId == t.Id).ToList());
}
}
}
// GET: api/Pegawai
public IEnumerable <pegawai> Get()
{
using (var db = new OcphDbContext())
{
var result = from a in db.Pegawai.Select()
join b in db.Bidang.Select() on a.IdBidang equals b.Id
join c in db.Jabatan.Select() on a.IdJabatan equals c.Id
select new pegawai {
Enrollment = a.Enrollment, Photo = a.Photo, Email = a.Email, Pengawas = a.Pengawas, Golongan = a.Golongan, Alamat = a.Alamat, Id = a.Id, IdBidang = a.IdBidang, IdJabatan = a.IdJabatan, JenisKelamin = a.JenisKelamin, Nama = a.Nama,
NIP = a.NIP, TanggalLahir = a.TanggalLahir, Telepon = a.Telepon, TempatLahir = a.TempatLahir, UserId = a.UserId, Bidang = b, Jabatan = c
};
return(result.ToList());
}
}
public bool DeleteLayanan(int Id)
{
using (var db = new OcphDbContext())
{
if (Id <= 0)
{
throw new ArgumentException("Pilih Layanan", "Id");
}
else
{
return(db.Layanans.Delete(O => O.Id == Id));
}
}
}
public bool ChangePassword(user user, string newPassword)
{
using (var db = new OcphDbContext())
{
if (!db.Users.Update(O => new { O.Password }, new user {
Password = newPassword
}, O => O.Id == User.Id))
{
throw new SystemException("Password Anda Tidak Berhasil Diubah");
}
return(true);
}
}
public async Task <List <DetailKrsm> > GetKRS()
{
try
{
if (Helper.IsInternetConnected.Item1)
{
using (var service = new RestService())
{
service.SetToken(Helper.Account.Token);
var profileResponse = await service.GetAsync($"api/jadwal/jadwalmahasiswa");
if (profileResponse.IsSuccessStatusCode)
{
var profileString = await profileResponse.Content.ReadAsStringAsync();
ResponseResult resResult = JsonConvert.DeserializeObject <ResponseResult>(profileString);
ResponseResult resResult2 = JsonConvert.DeserializeObject <ResponseResult>(resResult.data.ToString());
var krsresult = JsonConvert.DeserializeObject <KrsResult>(resResult2.data.ToString());
if (krsresult != null)
{
using (var db = new OcphDbContext())
{
await db.Connection.DeleteAllAsync <DetailKrsm>();
await db.Connection.InsertAllAsync(krsresult.DetailKrsm);
}
return(krsresult.DetailKrsm);
}
else
{
throw new SystemException("KRS Tidak Ditemukan, Hubungi BAAK");
}
}
else
{
throw new System.Exception(profileResponse.StatusCode.ToString());
}
}
}
else
{
throw new SystemException("Periksa Kembali Jaringan Internet Anda");
}
}
catch (Exception ex)
{
throw new SystemException(ex.Message);
}
}
public IActionResult Put(int id, Targetskp data)
{
try {
using (var db = new OcphDbContext(this._dbsetting)) {
var result = db.Kegiatan.Update(x => new { x.kegiatan, x.kuantitas, x.kualitas, x.waktu, x.biaya }, data, x => x.idtargetskp == id);
if (result)
{
return(Ok(result));
}
throw new System.Exception("Data Tidak Berhasil Diubah");
}
} catch (System.Exception ex) {
return(BadRequest(ex.Message));
}
}
public InboxCollection()
{
using (var db = new OcphDbContext())
{
var result = db.Connection.Table <InboxDataModel>().ToListAsync().Result;
var datas = result.OrderByDescending(x => x.Created);
foreach (var item in datas)
{
list.Add(item);
}
}
Load();
}
public bool Login()
{
using (var db = new OcphDbContext())
{
datauser = db.Users.Where(o => o.UserName == this.UserName && Password == this.Password).ToList();
if (datauser.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
}
private bool UserIsEmpty()
{
using (var db = new OcphDbContext())
{
var res = db.Users.Select().ToList();
if (res.Count <= 0)
{
return(true);
}
else
{
return(false);
}
}
}
public pemohon GetPemohonBy(string userId)
{
using (var db = new OcphDbContext())
{
var result = db.Pemohons.Where(O => O.UserId == userId).FirstOrDefault();
if (result != null)
{
return(result);
}
else
{
throw new SystemException("Anda Tidak Memiliki Akses");
}
}
}
public bool CreatePemohon(pemohon item)
{
using (var db = new OcphDbContext())
{
try
{
var result = db.Pemohons.Insert(item);
return(result);
}
catch (Exception ex)
{
throw new SystemException(ex.Message);
}
}
}
public permohonan GetLastPermohonan()
{
using (var db = new OcphDbContext())
{
var result = db.Permohonans.Where(O => O.IdPemohon == Pemohon.Id).FirstOrDefault();
if (result != null)
{
result.Kelengkapans = db.Kelengkapans.Where(O => O.IdPermohonan == result.Id).ToList();
result.Tahapans = db.Progress.Where(O => O.IdPermohonan == result.Id).ToList();
result.Layanan = db.Layanans.Where(O => O.Id == result.IdLayanan).FirstOrDefault();
}
return(result);
}
}
private async void picker_SelectedIndexChanged(object sender, EventArgs e)
{
var picker = sender as Picker;
if (picker.SelectedItem != null)
{
Helper.DataSetting.CurrentTheme = (Theme)picker.SelectedItem;
using (var db = new OcphDbContext())
{
await db.Connection.UpdateAsync(Helper.DataSetting);
ChangeTheme();
}
}
}
public Task <bool> UpdatePhotoSertifikat(permohonan item)
{
try
{
using (var db = new OcphDbContext())
{
var updated = db.Permohonans.Update(O => new { O.Photo }, item, O => O.Id == item.Id);
return(Task.FromResult(updated));
}
}
catch (Exception ex)
{
throw new SystemException(ex.Message);
}
}
public Task <planes> CreateNewPlane(planes item)
{
using (var db = new OcphDbContext())
{
item.Id = db.Planes.InsertAndGetLastID(item);
if (item.Id <= 0)
{
throw new SystemException("Data Tidak Tersimpan");
}
else
{
return(Task.FromResult(item));
}
}
}
private pengaturan GetPengaturan()
{
using (var db = new OcphDbContext())
{
var pengaturan = db.Setting.Select().FirstOrDefault();
if (pengaturan != null)
{
return(pengaturan);
}
else
{
throw new SystemException("Pengaturan Belum Anda, Tambahkan Pengaturan Baru");
}
}
}
