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());
}
}
