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