public ActionResult DeleteConfirmed(int id) { PrecoNacional precoNacional = db.PrecosNacionais.Find(id); db.PrecosNacionais.Remove(precoNacional); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,LinhaUn,Descricao,Apelido,Ipi,QtUnid,TipoProducaoId,I18Nivel1,I18Nivel2,I18Nivel3,I12Nivel1,I12Nivel2,I12Nivel3,I7Nivel1,I7Nivel2,I7Nivel3,Com,LlMin,PrecoRefer,AplicRoteiro,CustoDireto,RateioCustoFixo,Aumento")] PrecoNacional precoNacional) { if (ModelState.IsValid) { db.Entry(precoNacional).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TipoProducaoId = new SelectList(db.TiposProducao, "TipoProducaoId", "Descricao", precoNacional.TipoProducaoId); return(View(precoNacional)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PrecoNacional precoNacional = db.PrecosNacionais.Find(id); if (precoNacional == null) { return(HttpNotFound()); } return(View(precoNacional)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PrecoNacional precoNacional = db.PrecosNacionais.Find(id); if (precoNacional == null) { return(HttpNotFound()); } ViewBag.TipoProducaoId = new SelectList(db.TiposProducao, "TipoProducaoId", "Descricao", precoNacional.TipoProducaoId); return(View(precoNacional)); }
public static float I12Nivel1(PrecoNacional preco) // J { float result; using (var db = new ApplicationDbContext()) { string indice = XmlReader.Read("IndiceGestaoVenda"); float indiceGestao = db.Indices.Single(i => i.Descricao == indice).Terceiros; string taxa = XmlReader.Read("TaxaEfetivaVendaNacional"); float taxaEfetiva = db.Indices.Single(i => i.Descricao == taxa).Proprio; string despesa = XmlReader.Read("DespesaCobranca"); float despesaCobranca = db.Indices.Single(i => i.Descricao == despesa).Proprio; float temp = preco.TipoProducao.Descricao == "IND" ? db.IcmsFretes.Single(i => i.Rotulo == "12").Icms : 0; float temp2 = preco.QtUnid == 0 ? 1 : preco.QtUnid; result = (preco.CustoDireto + preco.RateioCustoFixo * preco.AplicRoteiro) * 0.66f / (0.66f * (1 - temp - 0.0925f - preco.Com - indiceGestao - (db.IcmsFretes.Single(i => i.Rotulo == "12").Frete + taxaEfetiva + despesaCobranca) * (1 + preco.Ipi)) - (preco.LlMin + 2 * 0.03f) * // 0.03f = Incr.LL 3,00% (1 - temp - 0.0925f)) / temp2; } return(result); }
public ActionResult DeleteConfirmed(int id) { PrecoNacional precoNacional = db.PrecosNacionais.Find(id); return(View("Erase", precoNacional)); }