public IActionResult KopirajPonudu(string broj) { var pon = _dbContext.ponuda.Include(p => p.partner).Include(p => p.Korisnik).FirstOrDefault(p => p.broj == broj); if (pon == null) { return(NotFound()); } else { try { var newPonuda = new ponuda(); Helper.CopyPropertiesTo <ponuda, ponuda>(pon, newPonuda); newPonuda.status = "E"; newPonuda.datum = DateTime.Now; var ponude = _dbContext.ponuda.Where(p => p.datum.Year == DateTime.Now.Year); string maxPonudaBroj = null; int year = newPonuda.datum.Year; int? brojPonude = null; if (ponude != null && ponude.Count() > 0) { maxPonudaBroj = ponude.Max(p => p.broj); int dbroj = int.Parse(maxPonudaBroj.Split("/")[0]); brojPonude = dbroj + 1; } else { brojPonude = 1; } newPonuda.broj = brojPonude.Value.ToString("D5") + "/" + year.ToString();; var stavke = _dbContext.ponuda_stavka.Where(s => s.ponuda_broj == pon.broj); var stavkePonude = new List <ponuda_stavka>(); foreach (var stavka in stavke) { var newPonudaStavka = new ponuda_stavka(); Helper.CopyPropertiesTo <ponuda_stavka, ponuda_stavka>(stavka, newPonudaStavka); newPonudaStavka.ponuda_broj = newPonuda.broj; newPonudaStavka.ponuda = newPonuda; stavkePonude.Add(newPonudaStavka); //_dbContext.ponuda_stavka.Add(newPonudaStavka); } newPonuda.stavke = stavkePonude; _dbContext.ponuda.Add(newPonuda); _dbContext.SaveChanges(); return(Ok(newPonuda)); } catch (Exception ex) { return(BadRequest()); } } }
public ActionResult DeleteConfirmed(int id) { ponuda ponuda = db.ponuda.Find(id); db.ponuda.Remove(ponuda); db.SaveChanges(); TempData["error"] = false; TempData["message"] = "Uspjesno ste izbrisali ponudu"; return(RedirectToAction("Index")); }
public IActionResult UpdatePonuda(ponuda ponuda) { ponuda.Korisnik = null; var pon = _dbContext.ponuda.FirstOrDefault(p => p.broj == ponuda.broj); if (pon == null) { return(NotFound()); } else { try { Helper.CopyPropertiesTo <ponuda, ponuda>(ponuda, pon); partner partner; if (ponuda.partner.sifra == null) { partner = new partner(); partner.naziv = ponuda.partner_naziv; partner.adresa = ponuda.partner_adresa; partner.maticni_broj = ponuda.partner_jib; partner.telefon = ponuda.partner_telefon; partner.email = ponuda.partner_email; partner.tip = "P"; pon.partner_sifra = null; pon.partner = partner; } else { partner = _dbContext.partner.Where(p => p.sifra == ponuda.partner_sifra).FirstOrDefault(); partner.naziv = ponuda.partner_naziv; partner.adresa = ponuda.partner_adresa; partner.maticni_broj = ponuda.partner_jib; partner.telefon = ponuda.partner_telefon; partner.email = ponuda.partner_email; partner.tip = "P"; _dbContext.SaveChanges(); pon.partner = partner; } _dbContext.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest(ex)); } } }
public ActionResult Edit([Bind(Include = "id_ponuda,cijena_ponude")] ponuda ponuda) { if (ModelState.IsValid) { db.Entry(ponuda).State = EntityState.Modified; db.SaveChanges(); TempData["error"] = false; TempData["message"] = "Uspjesno ste ažurirali ponudu"; return(RedirectToAction("Index")); } return(View(ponuda)); }
public bool Odgovor(ponuda clan, out int Bodovi) { if ((int)clan == tacan) { Bodovi = bodovi; return(true); } else { Bodovi = 0; return(false); } }
public ActionResult Create([Bind(Include = "id_ponuda,cijena_ponude")] ponuda ponuda) { if (ModelState.IsValid) { db.ponuda.Add(ponuda); db.SaveChanges(); TempData["error"] = false; TempData["message"] = "Uspjesno ste dodali ponudu"; return(RedirectToAction("Index")); } return(View(ponuda)); }
// GET: ponuda/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ponuda ponuda = db.ponuda.Find(id); if (ponuda == null) { return(HttpNotFound()); } return(View(ponuda)); }
public static string Stampa(ponuda p) { var culture = new System.Globalization.CultureInfo("en-US"); Thread.CurrentThread.CurrentCulture = culture; //string dir = Environment.SpecialFolder.MyDocuments + "\\ServisDB\\"; //string dir = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "temp"); string dir = "C:\\temp"; if (Directory.Exists(dir) == false) { Directory.CreateDirectory(dir); } XLWorkbook doc = new XLWorkbook("PONUDA.xlsm"); var sheet = doc.Worksheet(1); string rednibroj = p.broj; DateTime datum = p.datum.Date; string partner_naziv = p.partner_naziv; string partner_jib = p.partner_jib; string partner_adresa = p.partner_adresa; string valuta = p.valuta_placanja; string opcija_ponude = p.rok_vazenja; string rok_isporuke = p.rok_isporuke; string paritet = p.paritet; string paritet_kod = p.paritet_kod; string radnik = p.radnik; string iznos_bez_pdv = p.iznos_bez_rabata.ToString(); string rabat = p.rabat.ToString(); string iznos_sa_rabatom = p.iznos_sa_rabatom.ToString(); string pdv = p.pdv.ToString(); string iznos_sa_pdv = p.iznos_sa_pdv.ToString(); string broj = rednibroj; string[] parts = rednibroj.Split('/'); string rb = parts[0]; string year = parts[1]; int rrb = int.Parse(rb); rednibroj = rrb.ToString("D4") + "/" + year; sheet.Cells("A3").Value = "PONUDA BROJ: " + rednibroj; sheet.Cells("A3").DataType = XLDataType.Text; sheet.Cells("G2").Value = datum; sheet.Cells("G2").DataType = XLDataType.DateTime; sheet.Cells("G2").Style.NumberFormat.Format = "dd.MM.yyyy"; sheet.Cells("B7").Value = partner_naziv; sheet.Cells("B7").DataType = XLDataType.Text; sheet.Cells("B8").Value = partner_jib; sheet.Cells("B8").DataType = XLDataType.Text; sheet.Cells("B9").Value = partner_adresa; sheet.Cells("B9").DataType = XLDataType.Text; sheet.Cells("F7").Value = valuta; sheet.Cells("F7").DataType = XLDataType.Text; sheet.Cells("F8").Value = opcija_ponude; sheet.Cells("F8").DataType = XLDataType.Text; sheet.Cells("F9").Value = rok_isporuke; sheet.Cells("F9").DataType = XLDataType.Text; sheet.Cells("F10").Value = paritet_kod + " " + paritet; sheet.Cells("F10").DataType = XLDataType.Text; //List<PonudaStavka> stavke = PersistanceManager.ReadPonudaStavka(broj); int index = 0; string rowIndex = (14 + index).ToString(); int brojStavki = p.stavke.Count(); foreach (var stavka in p.stavke) { rowIndex = (14 + index).ToString(); sheet.Row(14 + index).Height = 20; sheet.Row(14 + index).Style.Font.FontName = "Arial"; sheet.Row(14 + index).Style.Font.FontSize = 10; sheet.Row(14 + index).Style.Font.FontColor = XLColor.Black; sheet.Row(14 + index).Style.Font.Bold = false; sheet.Row(14 + index).Style.Alignment.Vertical = XLAlignmentVerticalValues.Bottom; sheet.Cells("A" + rowIndex).Value = (index + 1).ToString(); sheet.Cells("A" + rowIndex).DataType = XLDataType.Text; sheet.Cells("A" + rowIndex).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; sheet.Cells("A" + rowIndex).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center; sheet.Cells("A" + rowIndex).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("A" + rowIndex).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("B" + rowIndex).Value = stavka.artikal_naziv.ToString() + Environment.NewLine + stavka.opis; sheet.Cells("B" + rowIndex).DataType = XLDataType.Text; sheet.Cells("B" + rowIndex).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Left; sheet.Cells("B" + rowIndex).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center; sheet.Cells("B" + rowIndex).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("B" + rowIndex).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("B" + rowIndex).Style.Alignment.WrapText = true; sheet.Row(14 + index).AdjustToContents(); sheet.Row(14 + index).ClearHeight(); sheet.Cells("C" + rowIndex).Value = stavka.jedinica_mjere.ToString(); sheet.Cells("C" + rowIndex).DataType = XLDataType.Text; sheet.Cells("C" + rowIndex).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; sheet.Cells("C" + rowIndex).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center; sheet.Cells("C" + rowIndex).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("C" + rowIndex).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("D" + rowIndex).Value = stavka.kolicina.ToString(); sheet.Cells("D" + rowIndex).DataType = XLDataType.Number; sheet.Cells("D" + rowIndex).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; sheet.Cells("D" + rowIndex).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center; sheet.Cells("D" + rowIndex).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("D" + rowIndex).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("E" + rowIndex).Value = stavka.cijena_bez_pdv.ToString(); sheet.Cells("E" + rowIndex).DataType = XLDataType.Number; sheet.Cells("E" + rowIndex).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("E" + rowIndex).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center; sheet.Cells("E" + rowIndex).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("E" + rowIndex).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("E" + rowIndex).Style.NumberFormat.Format = "#,##0.00 \"KM\""; sheet.Cells("F" + rowIndex).Value = stavka.rabat_procenat.ToString(); sheet.Cells("F" + rowIndex).DataType = XLDataType.Number; sheet.Cells("F" + rowIndex).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("F" + rowIndex).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center; sheet.Cells("F" + rowIndex).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("F" + rowIndex).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("F" + rowIndex).Style.NumberFormat.Format = "0.00%"; sheet.Cells("G" + rowIndex).Value = stavka.iznos_bez_pdv_sa_rabatom.ToString(); sheet.Cells("G" + rowIndex).DataType = XLDataType.Number; sheet.Cells("G" + rowIndex).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("G" + rowIndex).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center; sheet.Cells("G" + rowIndex).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("G" + rowIndex).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("G" + rowIndex).Style.NumberFormat.Format = "#,##0.00 \"KM\""; sheet.Cells("G" + rowIndex).Style.Font.Bold = false; index++; } sheet.Row(14 + brojStavki + 2).Height = 20; sheet.Row(14 + brojStavki + 3).Height = 20; sheet.Row(14 + brojStavki + 4).Height = 20; sheet.Row(14 + brojStavki + 5).Height = 20; sheet.Row(14 + brojStavki + 6).Height = 20; sheet.Cells("A" + (14 + brojStavki + 2).ToString()).Value = "UKUPAN IZNOS BEZ RABATA"; sheet.Cells("A" + (14 + brojStavki + 2).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("A" + (14 + brojStavki + 2).ToString()).Style.Font.Bold = false; sheet.Cells("A" + (14 + brojStavki + 2).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("A" + (14 + brojStavki + 2).ToString()).Style.Font.FontSize = 10; sheet.Cells("A" + (14 + brojStavki + 2).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("A" + (14 + brojStavki + 3).ToString()).Value = "IZNOS RABATA"; sheet.Cells("A" + (14 + brojStavki + 3).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("A" + (14 + brojStavki + 3).ToString()).Style.Font.Bold = false; sheet.Cells("A" + (14 + brojStavki + 3).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("A" + (14 + brojStavki + 3).ToString()).Style.Font.FontSize = 10; sheet.Cells("A" + (14 + brojStavki + 3).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("A" + (14 + brojStavki + 4).ToString()).Value = "UKUPAN IZNOS BEZ PDV"; sheet.Cells("A" + (14 + brojStavki + 4).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("A" + (14 + brojStavki + 4).ToString()).Style.Font.Bold = false; sheet.Cells("A" + (14 + brojStavki + 4).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("A" + (14 + brojStavki + 4).ToString()).Style.Font.FontSize = 10; sheet.Cells("A" + (14 + brojStavki + 4).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("A" + (14 + brojStavki + 5).ToString()).Value = "PDV"; sheet.Cells("A" + (14 + brojStavki + 5).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("A" + (14 + brojStavki + 5).ToString()).Style.Font.Bold = false; sheet.Cells("A" + (14 + brojStavki + 5).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("A" + (14 + brojStavki + 5).ToString()).Style.Font.FontSize = 10; sheet.Cells("A" + (14 + brojStavki + 5).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("A" + (14 + brojStavki + 6).ToString()).Value = "UKUPAN IZNOS SA PDV"; sheet.Cells("A" + (14 + brojStavki + 6).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("A" + (14 + brojStavki + 6).ToString()).Style.Font.Bold = false; sheet.Cells("A" + (14 + brojStavki + 6).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("A" + (14 + brojStavki + 6).ToString()).Style.Font.FontSize = 10; sheet.Cells("A" + (14 + brojStavki + 6).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Range("A" + (14 + brojStavki + 2).ToString() + ":" + "F" + (14 + brojStavki + 2).ToString()).Row(1).Merge(); sheet.Range("A" + (14 + brojStavki + 3).ToString() + ":" + "F" + (14 + brojStavki + 3).ToString()).Row(1).Merge(); sheet.Range("A" + (14 + brojStavki + 4).ToString() + ":" + "F" + (14 + brojStavki + 4).ToString()).Row(1).Merge(); sheet.Range("A" + (14 + brojStavki + 5).ToString() + ":" + "F" + (14 + brojStavki + 5).ToString()).Row(1).Merge(); sheet.Range("A" + (14 + brojStavki + 6).ToString() + ":" + "F" + (14 + brojStavki + 6).ToString()).Row(1).Merge(); sheet.Range("A" + (14 + brojStavki + 2).ToString() + ":" + "F" + (14 + brojStavki + 2).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.None; sheet.Range("A" + (14 + brojStavki + 3).ToString() + ":" + "F" + (14 + brojStavki + 3).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.None; sheet.Range("A" + (14 + brojStavki + 4).ToString() + ":" + "F" + (14 + brojStavki + 4).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.None; sheet.Range("A" + (14 + brojStavki + 5).ToString() + ":" + "F" + (14 + brojStavki + 5).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.None; sheet.Range("A" + (14 + brojStavki + 6).ToString() + ":" + "F" + (14 + brojStavki + 6).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.None; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Value = iznos_bez_pdv; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).DataType = XLDataType.Number; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.NumberFormat.Format = "#,##0.00 \"KM\""; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.Font.Bold = true; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.Font.FontSize = 10; sheet.Cells("G" + (14 + brojStavki + 2).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Value = rabat; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).DataType = XLDataType.Number; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.NumberFormat.Format = "#,##0.00 \"KM\""; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.Font.Bold = true; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.Font.FontSize = 10; sheet.Cells("G" + (14 + brojStavki + 3).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Value = iznos_sa_rabatom; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).DataType = XLDataType.Number; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.NumberFormat.Format = "#,##0.00 \"KM\""; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.Font.Bold = true; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.Font.FontSize = 10; sheet.Cells("G" + (14 + brojStavki + 4).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Value = pdv; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).DataType = XLDataType.Number; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.NumberFormat.Format = "#,##0.00 \"KM\""; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.Font.Bold = true; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.Font.FontSize = 10; sheet.Cells("G" + (14 + brojStavki + 5).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Value = iznos_sa_pdv; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).DataType = XLDataType.Number; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.Border.OutsideBorder = XLBorderStyleValues.Thin; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.Border.OutsideBorderColor = XLColor.FromArgb(216, 228, 188); sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.NumberFormat.Format = "#,##0.00 \"KM\""; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.Font.Bold = true; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.Font.FontSize = 10; sheet.Cells("G" + (14 + brojStavki + 6).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("E" + (14 + brojStavki + 8).ToString()).Style.Font.FontName = "Arial"; sheet.Cells("E" + (14 + brojStavki + 8).ToString()).Style.Font.FontSize = 10; sheet.Cells("E" + (14 + brojStavki + 8).ToString()).Style.Font.FontColor = XLColor.Black; sheet.Cells("E" + (14 + brojStavki + 8)).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right; sheet.Cells("E" + (14 + brojStavki + 8).ToString()).Value = "Dokument sastavio: " + p.Korisnik.ime + " " + p.Korisnik.prezime; sheet.Range("E" + (14 + brojStavki + 8) + ":G" + (14 + brojStavki + 8)).Row(1).Merge(); sheet.Cells("F" + (14 + brojStavki + 12).ToString()).Value = "M.P."; sheet.Cells("A" + (14 + brojStavki + 16).ToString()).Value = "Hvala na povjerenju!"; sheet.Range("A" + (14 + brojStavki + 16).ToString() + ":" + "G" + (14 + brojStavki + 16).ToString()).Row(1).Merge(); sheet.Cells("A" + (14 + brojStavki + 16).ToString()).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; var imagePath = "footer.jpg"; var image = sheet.AddPicture(imagePath) .MoveTo(sheet.Cell("A" + (14 + brojStavki + 16).ToString())).Scale(0.1); string fileName = dir + "\\MINTICT_Ponuda_" + rednibroj.Replace("/", "-") + ".xlsm"; if (File.Exists(fileName) == true) { try { File.Delete(fileName); } catch (Exception ex) { return(null); } doc.SaveAs(fileName); } else { doc.SaveAs(fileName); } return(fileName); }
public IActionResult InsertPonuda(ponuda ponuda) { try { var ponude = _dbContext.ponuda.Where(p => p.datum.Year == DateTime.Now.Year); string maxPonudaBroj = null; int year = ponuda.datum.Year; int? broj = null; if (ponude != null && ponude.Count() > 0) { maxPonudaBroj = ponude.Max(p => p.broj); int dbroj = int.Parse(maxPonudaBroj.Split("/")[0]); broj = dbroj + 1; } else { broj = 1; } ponuda.radnik = User.Identity.Name; ponuda.status = "E"; ponuda.broj = broj.Value.ToString("D5") + "/" + year.ToString(); ponuda.iznos_bez_rabata = 0; ponuda.iznos_sa_pdv = 0; ponuda.iznos_sa_pdv = 0; ponuda.pdv = 0; ponuda.iznos_sa_rabatom = 0; ponuda.rabat = 0; partner partner; if (ponuda.partner.sifra == null) { partner = new partner(); partner.naziv = ponuda.partner_naziv; partner.adresa = ponuda.partner_adresa; partner.maticni_broj = ponuda.partner_jib; partner.telefon = ponuda.partner_telefon; partner.email = ponuda.partner_email; partner.tip = "P"; ponuda.partner = partner; } else { partner = _dbContext.partner.Where(p => p.sifra == ponuda.partner_sifra).FirstOrDefault(); partner.naziv = ponuda.partner_naziv; partner.adresa = ponuda.partner_adresa; partner.maticni_broj = ponuda.partner_jib; partner.telefon = ponuda.partner_telefon; partner.email = ponuda.partner_email; partner.tip = "P"; _dbContext.SaveChanges(); ponuda.partner = partner; } _dbContext.ponuda.Add(ponuda); _dbContext.SaveChanges(); ponuda.Korisnik = _dbContext.korisnik.FirstOrDefault(k => k.korisnicko_ime == ponuda.radnik); return(Ok(ponuda)); } catch (Exception ex) { _logger.LogError(ex, "Exception"); return(BadRequest(ex)); } }