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