public async Task <IActionResult> Edit(int id, ProfitPierdere profitPierdere) { if (id != profitPierdere.ProfitPierdereId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.ProfitPierdere.Update(profitPierdere); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProfitPierdereExists(profitPierdere.ProfitPierdereId)) { return(NotFound()); } else { throw; } } TempData["Message"] = "Solduri profit pierdere actualizate cu succes!"; TempData["Success"] = "true"; return(RedirectToAction(nameof(Index))); } ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(x => x.Denumire), "ClientId", "Denumire", profitPierdere.ClientId); return(View(profitPierdere)); }
private static ProfitPierdere CreateProfitPierdere(XElement profitP, ImportBalanteXMLVM balanta) { ProfitPierdere profitPierdere = new ProfitPierdere() { deb_prec = float.Parse(profitP.Element("deb_prec").Value), cred_prec = float.Parse(profitP.Element("cred_prec").Value), rulaj_d = float.Parse(profitP.Element("rulaj_d").Value), rulaj_c = float.Parse(profitP.Element("rulaj_c").Value), fin_d = float.Parse(profitP.Element("fin_d").Value), fin_c = float.Parse(profitP.Element("fin_c").Value), ClientId = balanta.ClientId, Year = balanta.Year, Month = balanta.Month }; // daca veniturile sunt mai mari atunci avem profit if (profitPierdere.rulaj_c > profitPierdere.rulaj_d) { profitPierdere.Profit_luna = profitPierdere.rulaj_c - profitPierdere.rulaj_d; } // altfel avem pierdere else { profitPierdere.Pierdere_luna = profitPierdere.rulaj_c - profitPierdere.rulaj_d; } return(profitPierdere); }
public async Task <IActionResult> ManualCreate(ProfitPierdere profitPierdere) { if (ModelState.IsValid) { _context.ProfitPierdere.Add(profitPierdere); await _context.SaveChangesAsync(); TempData["Message"] = "Solduri profit pierdere adaugate cu succes!"; TempData["Success"] = "true"; return(RedirectToAction(nameof(Index))); } ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(x => x.Denumire), "ClientId", "Denumire", profitPierdere.ClientId); return(View(profitPierdere)); }
public async Task <IActionResult> Create(ImportBalanteXMLVM balanta) { var user = await _userManager.GetUserAsync(User); var documentType = _context.TipDocument.FirstOrDefault(u => u.Denumire == "XML").TipDocumentId; if (Path.GetExtension(balanta.DocumentPathUrl.FileName).ToLower() != ".xml") { // if we don't have a xml document TempData["Message"] = "Va rugam incarcati un document in format XML!"; TempData["Success"] = ""; ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(u => u.Denumire), "ClientId", "Denumire", balanta.ClientId); return(View(balanta)); } Document document = new Document() { ApplicationUserId = user.Id, ClientId = balanta.ClientId, TipDocumentId = documentType, DocumentPath = await _fileManager.SaveDocument(balanta.DocumentPathUrl, "XML", balanta.ClientId, user.Id), }; if (ModelState.IsValid) { _context.Document.Add(document); var fullPath = $"C:/Users/user/source/repos/Licenta/wwwroot/xml/{document.DocumentPath}"; XDocument doc = XDocument.Load(fullPath); var balante = from bal in doc.Root.Elements() where bal.Element("cont").Value.ToString().Equals("121") select bal; foreach (XElement bal in balante) { ProfitPierdere profitPierdere = CreateProfitPierdere(bal, balanta); _context.Add(profitPierdere); } _fileManager.DeleteDocumentXML(document.DocumentPath); _context.Document.Remove(document); _context.SaveChanges(); } ViewData["ClientId"] = new SelectList(_context.Client.OrderBy(u => u.Denumire), "ClientId", "Denumire", balanta.ClientId); TempData["Message"] = "Solduri profit-pierdere importate cu succes!"; TempData["Success"] = "true"; return(RedirectToAction(nameof(Index))); }
public async Task <IActionResult> DeleteAPI(int id) { ProfitPierdere profitPierdere = _context.ProfitPierdere.Find(id); if (profitPierdere == null) { return(Json(new { success = false, message = "Eroare la stergerea soldurilor de profit/pierdere!" })); } else { try { _context.ProfitPierdere.Remove(profitPierdere); await _context.SaveChangesAsync(); return(Json(new { success = true, message = "Solduri profit/pierdere sterse cu succes!" })); } catch { return(Json(new { success = false, message = "Eroare la stergerea soldurilor de profit/pierdere!" })); } } }