public async Task <ActionResult <Odehar> > PostOdehar(Odehar odehar)
        {
            _context.Odehar.Add(odehar);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetOdehar", new { id = odehar.Ohid }, odehar));
        }
        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());
        }
Exemple #3
0
        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());
            }
        }