public async Task <IActionResult> PutKasahar(int id, Kasahar kasahar) { if (id != kasahar.Khid) { return(BadRequest()); } _context.Entry(kasahar).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!KasaharExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Kasahar> > PostKasahar(Kasahar kasahar) { //para transferi için transaction ekle _context.Kasahar.Add(kasahar); await _context.SaveChangesAsync(); return(CreatedAtAction("GetKasahar", new { id = kasahar.Khid }, kasahar)); }
public async Task <IActionResult> PutTahsilat(tahsput tp) { var transaction = _context.Database.BeginTransaction(); try { Tahsilat tah = await _context.Tahsilat.SingleOrDefaultAsync(p => p.Tahsid == tp.id); if ((tah.Topmik - tah.Alinmismik) - tp.alinmismik == 0) { List <Fatura> w = await _context.Fatura.Where(u => u.Tahsid == tp.id).ToListAsync(); w[0].Durum = 1; tah.Durum = 1; tah.Alinmismik = tp.toplam; } else { tah.Alinmismik = tah.Alinmismik + tp.alinmismik; } Tahshar har = new Tahshar(); har.Tahsid = tp.id; har.Tediltar = tp.tedt; har.Kasaid = tp.kasid; har.Aciklama = tp.acik; har.Alinmismik = tp.alinmismik; _context.Tahshar.Add(har); await _context.SaveChangesAsync(); Kasahar kashar = new Kasahar { }; kashar.Kasaid = tp.kasid; kashar.Durum = 1; kashar.Miktar = tp.alinmismik; kashar.Miktaraciklamasi = tp.acik; kashar.Thid = har.Thid; kashar.Netbakiye = -1; _context.Kasahar.Add(kashar); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TahsilatExists(tp.id)) { transaction.Rollback(); return(NotFound()); } else { throw; } } transaction.Commit(); return(Ok()); } catch (Exception e) { transaction.Rollback(); return(NotFound()); } }
public async Task <IActionResult> PutOdemeler(odeput op) { var transaction = _context.Database.BeginTransaction(); try { Odemeler od = await _context.Odemeler.SingleOrDefaultAsync(p => p.Odeid == op.id); if ((od.Topmik - op.odendim) - op.odendim == 0) { List <Fatura> w = await _context.Fatura.Where(u => u.Odeid == op.id).ToListAsync(); w[0].Durum = 1; od.Durum = 1; od.Odendimik = od.Topmik; } else { od.Odendimik = od.Odendimik + op.odendim; } Odehar har = new Odehar(); har.Odeid = op.id; har.Odenmistar = op.odent; har.Kasaid = op.kasid; har.Aciklama = op.acik; har.Odendimik = op.odendim; _context.Odehar.Add(har); await _context.SaveChangesAsync(); Kasahar kashar = new Kasahar { }; kashar.Kasaid = op.kasid; kashar.Durum = 0; kashar.Miktar = op.odendim; kashar.Miktaraciklamasi = op.acik; kashar.Ohid = har.Ohid; kashar.Netbakiye = -1; _context.Kasahar.Add(kashar); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OdemelerExists(op.id)) { transaction.Rollback(); return(NotFound()); } else { throw; } } transaction.Commit(); return(Ok()); } catch (Exception e) { transaction.Rollback(); return(NotFound()); } }
public async Task <ActionResult <Fatura> > PostFatura(postfatura pf) { var transaction = _context.Database.BeginTransaction(); try { if (pf.sipa.FatTur == 1) { Tahsilat tah = new Tahsilat { }; tah.Kasaid = pf.sipa.kasaid; tah.Aciklama = pf.sipa.tahac ?? ""; tah.Durum = pf.sipa.durum; if (pf.sipa.durum == 1) { tah.Tediltar = pf.sipa.tedt; } else { tah.Vadetarih = pf.sipa.vadt; } tah.Alinmismik = pf.sipa.alinm; tah.Topmik = pf.sipa.topm; tah.Fatad = pf.sipa.Fataciklama; tah.Duzt = pf.sipa.Duztarih; Fatura fa = new Fatura { }; fa.Tahs = tah; fa.Geneltoplam = pf.sipa.topm; fa.Katid = 1; fa.CariId = pf.sipa.CariId; fa.Duztarih = pf.sipa.Duztarih; fa.FatTur = pf.sipa.FatTur; fa.Fataciklama = pf.sipa.Fataciklama; fa.Katid = pf.sipa.Katid; fa.Aratop = pf.sipa.Aratop; fa.Kdv = pf.sipa.Kdv; if (pf.sipa.durum == 1) { fa.Durum = 1; } else { fa.Durum = 0; } fa.Urunhareket = pf.hareket; _context.Fatura.Add(fa); await _context.SaveChangesAsync(); if (pf.sipa.durum == 1) { Tahshar har = new Tahshar(); har.Tahsid = fa.Tahsid ?? -1; har.Tediltar = pf.sipa.tedt ?? DateTime.Now; har.Kasaid = pf.sipa.kasaid; har.Aciklama = pf.sipa.Fataciklama ?? ""; har.Alinmismik = pf.sipa.alinm; _context.Tahshar.Add(har); await _context.SaveChangesAsync(); Kasahar kashar = new Kasahar { }; kashar.Kasaid = pf.sipa.kasaid; kashar.Durum = 1; kashar.Miktar = pf.sipa.alinm; kashar.Miktaraciklamasi = pf.sipa.Fataciklama; kashar.Thid = har.Thid; kashar.Netbakiye = -1; _context.Kasahar.Add(kashar); await _context.SaveChangesAsync(); } transaction.Commit(); return(CreatedAtAction("GetFatura", new { id = fa.Fatid }, fa)); } Odemeler ode = new Odemeler { }; ode.Kasaid = pf.sipa.kasaid; ode.Aciklama = pf.sipa.tahac ?? ""; ode.Durum = pf.sipa.durum; if (pf.sipa.durum == 1) { ode.Odenmistar = pf.sipa.vadt; } else { ode.Odenecektar = pf.sipa.tedt; } ode.Odendimik = pf.sipa.alinm; ode.Topmik = pf.sipa.topm; ode.Fatad = pf.sipa.Fataciklama; ode.Duzt = pf.sipa.Duztarih; Fatura fat = new Fatura { }; fat.Ode = ode; fat.Geneltoplam = pf.sipa.topm; fat.Katid = 1; fat.CariId = pf.sipa.CariId; fat.Duztarih = pf.sipa.Duztarih; fat.FatTur = pf.sipa.FatTur; fat.Fataciklama = pf.sipa.Fataciklama; fat.Katid = pf.sipa.Katid; fat.Aratop = pf.sipa.Aratop; fat.Kdv = pf.sipa.Kdv; if (pf.sipa.durum == 1) { fat.Durum = 1; } else { fat.Durum = 0; } fat.Urunhareket = pf.hareket; _context.Fatura.Add(fat); await _context.SaveChangesAsync(); if (pf.sipa.durum == 1) { Odehar har = new Odehar(); har.Odeid = fat.Odeid ?? -1; har.Odenmistar = pf.sipa.tedt ?? DateTime.Now; har.Kasaid = pf.sipa.kasaid; har.Aciklama = pf.sipa.Fataciklama ?? ""; har.Odendimik = pf.sipa.alinm; _context.Odehar.Add(har); await _context.SaveChangesAsync(); Kasahar kashar = new Kasahar { }; kashar.Kasaid = pf.sipa.kasaid; kashar.Durum = 1; kashar.Miktar = pf.sipa.alinm; kashar.Miktaraciklamasi = pf.sipa.Fataciklama; kashar.Ohid = har.Ohid; kashar.Netbakiye = -1; _context.Kasahar.Add(kashar); await _context.SaveChangesAsync(); } transaction.Commit(); return(CreatedAtAction("GetFatura", new { id = fat.Fatid }, fat)); } catch (Exception e) { transaction.Rollback(); return(NotFound()); } }