public ActionResult DeleteConfirmed(int id) { Klients klients = db.Klients.Find(id); db.Klients.Remove(klients); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID_Klients,Sername,Names,Patronymic")] Klients klients) { if (ModelState.IsValid) { db.Entry(klients).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(klients)); }
public async Task <IActionResult> UpdateCustomer([FromBody] Klients klients) { var result = await _repository.UpdateKlientsAsync(klients); if (result > 0) { return(StatusCode(200, new { message = "Klienta dati atjaunināti" })); } return(StatusCode(200, new { message = "Nav izmaiņu ko saglabāt" })); }
public ActionResult Create([Bind(Include = "ID_Klients,Sername,Names,Patronymic")] Klients klients) { if (ModelState.IsValid) { db.Klients.Add(klients); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(klients)); }
// GET: Klients/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Klients klients = db.Klients.Find(id); if (klients == null) { return(HttpNotFound()); } return(View(klients)); }
public async Task <int> InsertKlientsAsync(Klients klients) { if (klients.Veids == KlientaVeids.FiziskaPersona) { _memoryCache.Remove("CUSTOMERS-NATURAL-LIST"); } else if (klients.Veids == KlientaVeids.JuridiskaPersona) { _memoryCache.Remove("CUSTOMERS-LEGAL-LIST"); } else { throw new BadRequestException("Nezināms klienta veids"); } _memoryCache.Remove("TODAY-STATUS"); await _context.Klienti.AddAsync(klients); await _context.SaveChangesAsync(); return(klients.Id); }
public async Task <IActionResult> InsertCustomer([FromBody] Klients klients) { var result = await _repository.InsertKlientsAsync(klients); return(StatusCode(200, new { id = result.ToString(), message = "Izveidots jauns klients" })); }
public async Task <int> UpdateKlientsAsync(Klients klients) { if (klients.Veids == KlientaVeids.FiziskaPersona) { _memoryCache.Remove("CUSTOMERS-NATURAL-LIST"); } else if (klients.Veids == KlientaVeids.JuridiskaPersona) { _memoryCache.Remove("CUSTOMERS-LEGAL-LIST"); } else { throw new BadRequestException("Nezināms klienta veids"); } var customer = await _context.Klienti .Where(c => c.Id == klients.Id) .Include(c => c.Adreses) .Include(c => c.Bankas) .FirstOrDefaultAsync(); if (customer == null) { throw new BadRequestException("Klients neeksistē"); } var result = 0; #region Adreses var addrToBeRemoved = (from a in customer.Adreses where !klients.Adreses.Any(c => c.Id > 0 && c.Id == a.Id) select a).ToList(); var addrToBeAdded = (from a in klients.Adreses where !customer.Adreses.Any(e => a.Id == e.Id) select a).ToList(); if (addrToBeRemoved.Count > 0) // izdzēšam noņemtās adreses { foreach (var a in addrToBeRemoved) { customer.Adreses.Remove(a); } } if (addrToBeAdded.Count > 0) // pievienojam jaunās { foreach (var a in addrToBeAdded) { customer.Adreses.Add(new KlientaAdrese { Veids = a.Veids, Nosaukums = a.Nosaukums }); } } // lai atjauninātu izmaiņas esošajās adresēs result = await _context.SaveChangesAsync(); foreach (var addr in customer.Adreses) { var na = klients.Adreses.Where(a => a.Id == addr.Id).FirstOrDefault(); if (na != null) { addr.Veids = na.Veids; addr.Nosaukums = na.Nosaukums; } } #endregion #region Bankas if (klients.Veids == KlientaVeids.JuridiskaPersona) { var banksToBeRemoved = (from b in customer.Bankas where !klients.Bankas.Any(c => c.Id > 0 && c.Id == b.Id) select b).ToList(); var banksToBeAdded = (from b in klients.Bankas where !customer.Bankas.Any(e => b.Id == e.Id) select b).ToList(); if (banksToBeRemoved.Count > 0) // izdzēšam noņemtās bankas { foreach (var b in banksToBeRemoved) { customer.Bankas.Remove(b); } } if (banksToBeAdded.Count > 0) // pievienojam jaunās { foreach (var b in banksToBeAdded) { customer.Bankas.Add(new KlientaBanka { Nosaukums = b.Nosaukums, Kods = b.Kods, Konts = b.Konts }); } } // lai atjauninātu izmaiņas esošajās bankās result += await _context.SaveChangesAsync(); foreach (var bank in customer.Bankas) { var nb = klients.Bankas.Where(b => b.Id == bank.Id).FirstOrDefault(); if (nb != null) { bank.Nosaukums = nb.Nosaukums; bank.Konts = nb.Konts; bank.Kods = nb.Kods; } } } #endregion #region Dati customer.Nosaukums = klients.Nosaukums; customer.RegNumurs = klients.RegNumurs; customer.PvnNumurs = klients.PvnNumurs; customer.Epasts = klients.Epasts; customer.Talrunis = klients.Talrunis; customer.Piezimes = klients.Piezimes; #endregion result += await _context.SaveChangesAsync(); return(result); }