public ActionResult Edit([Bind(Include = "InvoiceID,CompanyID,ProductInvoiceID,InvoiceDate,InvoiceEndDate,Project,TotalPrice,DateCreated,DateModified,UserName")] Fakturi fakturi) { if (ModelState.IsValid) { db.Entry(fakturi).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CompanyID = new SelectList(db.Companies, "CompanyID", "UserId", fakturi.CompanyID); return(View(fakturi)); }
private void buttonFakturiFAKTURI_A_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; int i = 0; foreach (var fd in _mladinskaEntities.FAKTURI_A) { var fd1 = fd; if (_avtorskaEntities.Fakturi.Count(d => d.Broj == fd1.BROJ && d.Godina == fd1.GODINA && fd1.prazno == "A") == 0) { var faktura = new Fakturi { Broj = fd1.BROJ, Godina = fd1.GODINA, Neto = (decimal?)fd1.NETO, DanocnaOsnovica = (decimal?)fd1.DANOSN, Trosoci = (decimal?)fd1.TROSOCI, DDV_Osnovica = (decimal?)fd1.DDV_OSN, DDV_Iznos = (decimal?)fd1.DDV_IZN, DDV_Stapka = (decimal?)fd1.DDV_STAPKA, Iznos = (decimal?)fd1.IZNOS, PersonalenDanok = (decimal?)fd1.PERSDANOK, Personalen_Stapka = (decimal?)fd1.PERS_STAPKA, Popust = (decimal?)fd1.POPUST, Tekst = fd1.TEKST, DOG_K = fd1.DOG_K, GOD_K = fd1.GOD_K, Plateno = (decimal?)fd1.PLATENO, DatumPlateno = fd1.DATUMP, GL_Spisok = fd1.GL_SPISOK, GOD_S = fd1.GOD_S, prazno = "A", tempf = (decimal?)fd1.tempf, Seuste_Ne = fd1.SEUSTE_NE }; DateTime dateTime; if (DateTime.TryParse(fd1.DATUMF, out dateTime)) { if (dateTime >= Convert.ToDateTime("1753/1/1") && dateTime <= DateTime.MaxValue) { faktura.Datum = dateTime; } } _avtorskaEntities.AddToFakturi(faktura); _avtorskaEntities.SaveChanges(); } } Cursor.Current = Cursors.Default; MessageBox.Show("FAKTURI_A => Fakturi : " + i); }
// GET: Invoices/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Fakturi fakturi = db.Fakturis.Find(id); if (fakturi == null) { return(HttpNotFound()); } return(View(fakturi)); }
// GET: Invoices/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Fakturi fakturi = db.Fakturis.Find(id); if (fakturi == null) { return(HttpNotFound()); } ViewBag.CompanyID = new SelectList(db.Companies, "CompanyID", "UserId", fakturi.CompanyID); return(View(fakturi)); }
public ActionResult DeleteConfirmed(int id) { Fakturi fakturi = dbAkcet.Fakturis.Find(id); foreach (var product in dbAkcet.ProductInvoices.Where(p => p.InvoiceID == id)) { dbAkcet.ProductInvoices.Remove(product); } var counter = Int32.Parse(fakturi.FakturaNumber.Split('-')[1]) + 1; var counterTbl = dbAkcet.Counters.Where(c => c.CounterValue == counter && c.UserID == fakturi.UserID).FirstOrDefault(); // TODO: When invoice is deleted counter is still in max value dbAkcet.Fakturis.Remove(fakturi); dbAkcet.SaveChanges(); return(RedirectToAction("Index")); }
public JsonResult SaveInvoiceConfirmed(bool value) { try { var userId = User.Identity.GetUserId(); var model = GetInvoiceTempModel(userId); // TODO: Set Counter for each user for every year var tempCounter = db.Counters .FirstOrDefault(c => c.UserID == userId && c.Year == DateTime.Now.Year.ToString()); if (tempCounter != null) { tempCounter.CounterValue++; } //var counter = db.Counters.OrderByDescending(s => s.CounterValue).FirstOrDefault(c => c.Year == DateTime.Now.Year.ToString()); //counter.CounterValue++; //db.Counters.Add(counter); // TODO: Set Counter for each user for every year var faktura = new Fakturi(); faktura.CompanyID = model.CompanyID; faktura.InvoiceDate = DateTime.Parse(model.InvoiceDate); faktura.InvoiceEndDate = DateTime.Parse(model.InvoiceEndDate); faktura.TotalPrice = model.TotalWithDDS; faktura.Period = model.Period ?? " "; faktura.FakturaNumber = model.InvoiceNumber; faktura.FakturaHtml = RenderViewToString("Index", model); faktura.UserID = userId; faktura.UserName = User.Identity.Name; faktura.DateCreated = DateTime.Now; faktura.DateModified = DateTime.Now; db.Fakturis.Add(faktura); var products = new List <ProductInvoice>(); foreach (var productTemp in model.ProductsListTemp) { products.Add(new ProductInvoice() { InvoiceID = faktura.InvoiceID, DdsID = productTemp.DdsID, ProductID = productTemp.ProductID, ProjectID = productTemp.ProjectID, Quantity = productTemp.Quanity, TotalPrice = productTemp.ProductTotalPrice }); } products.ForEach(s => db.ProductInvoices.Add(s)); db.SaveChanges(); byte[] bytes = GeneratePDF(faktura.FakturaHtml.Replace("\r\n", string.Empty)); string strEmailResult = "<img src=\"" + ConfigurationManager.AppSettings["SocialLogoPath"] + "\">"; EmailFunctions.SendEmail(ConfigurationManager.AppSettings["AdminEmail"], "New invoice from user " + User.Identity.Name, strEmailResult, bytes, DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".pdf"); return(Json(faktura.FakturaHtml, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { EmailFunctions.SendExceptionToAdmin(ex); return(Json(false, JsonRequestBehavior.AllowGet)); } }