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