public async Task <IActionResult> PutCari(int id, Cari cari) { if (id != cari.CariId) { return(BadRequest()); } _context.Entry(cari).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CariExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutKasa(int id, Kasa kasa) { if (id != kasa.Kasaid) { return(BadRequest()); } _context.Entry(kasa).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!KasaExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutUrun(string id, Urun urun) { if (id != urun.Barkodno) { return(BadRequest()); } _context.Entry(urun).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UrunExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutOdehar(int id, Odehar odehar) { if (id != odehar.Ohid) { return(BadRequest()); } _context.Entry(odehar).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OdeharExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult> getirsurungun(int fid, List <int> irsid) { List <Urunhareket> li = await _context.Urunhareket.Where(a => irsid.Contains(a.Irsid ?? -1)).ToListAsync(); int m = li.Count(); for (int k = 0; k < m; k++) { li[k].Fatid = fid; } await _context.SaveChangesAsync(); return(Ok()); }
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> PutIrsaliye(int id) { var transaction = _context.Database.BeginTransaction(); try { // DateTime g = Convert.ToDateTime(ilktar); // DateTime t = Convert.ToDateTime(sontar); List <Irsaliye> irli = await _context.Irsaliye.Where(a => a.CariId == id && a.Fatmi == 0)//.Where(b => b.Tarih >= g && b.Tarih <= t) .ToListAsync(); float arat = 0; float arai = 0; float kd = 0; float ge = 0; int m = irli.Count(); int n = 0; for (int k = 0; k < m; k++) { irli[k].Fatmi = 1; arat = arat + irli[k].Aratop; // arai = arai + irli[k].Araind; kd = kd + irli[k].Kdv; ge = ge + irli[k].Geneltop; } Tahsilat tah = new Tahsilat { }; tah.Kasaid = 9; tah.Aciklama = ""; tah.Durum = 0; tah.Vadetarih = DateTime.Now; tah.Alinmismik = 0; tah.Topmik = ge; tah.Fatad = ""; tah.Duzt = DateTime.Now; Fatura fa = new Fatura { }; fa.Tahs = tah; fa.Geneltoplam = ge; fa.Katid = 1; fa.CariId = id; fa.Duztarih = DateTime.Now; fa.FatTur = 1; fa.Fataciklama = "irsaliyefaturası " + DateTime.Now.ToShortTimeString(); fa.Katid = 1; fa.Aratop = arat; fa.Kdv = kd; fa.Durum = 0; // fa.Urunhareket= new List<Urunhareket>();//pf.hareket; _context.Fatura.Add(fa); Fatura fatu = fa; await _context.SaveChangesAsync(); int z = irli.Count(); List <int> idler = new List <int>(); for (int o = 0; o < z; o++) { idler.Add(irli[o].Irsid); } List <Urunhareket> li = await _context.Urunhareket.Where(a => idler.Contains(a.Irsid ?? -1)).ToListAsync(); int q = li.Count(); for (int k = 0; k < q; k++) { li[k].Fatid = fa.Fatid; } await _context.SaveChangesAsync(); transaction.Commit(); return(Ok(fatu));//CreatedAtAction("GetFatura", new { id = fa.Fatid }, fa); } 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()); } }