public ActionResult RemoveItemGarantia(int id) { // Remove the item from the cart GarantiaItem varDelete = db.GarantiaItem.Where(p => p.garantiaitemid == id).Single(); db.GarantiaItem.Remove(varDelete); try { db.SaveChanges(); decimal total = AtualizaTotalGarantia(varDelete.garantiaid); return(Json(new { id = id, Msg = "Ok, Atualizado item com suceso ", total = total, hasError = false })); } catch (Exception e) { return(Json(new { id = id, Msg = e.Message, total = GetTotalGarantia(varDelete.garantiaid), hasError = true })); } }
//public class ViewModel //{ // public int CodeClass { get; set; } //class is reserved word // public int TransferCount { get; set; } //} // http://localhost:57042/RecGarantias/ReceiveOrder/32958 //[HttpPost] //public ActionResult GetData(IEnumerable<GarantiaItem> data, FormCollection f) //{ // return Json(new { Data = data }); //} public ActionResult AddOrRemove(int garantiaId, int garantiaitemid, string cod_foxlux, int cod_item, bool isDelete, decimal qtd_recebida, decimal qtd_atendida, decimal qtd_fora_garantia, decimal qtd_outras_marcas, decimal qtd_faltante, decimal qtd_avariada, decimal qtd_descartada) { // GarantiaItem data_update = db.GarantiaItem.Find(garantiaId, garantiaitemid, cod_foxlux, cod_item); GarantiaItem data_update = db.GarantiaItem.Where(a => a.garantiaitemid == garantiaitemid).First(); data_update.qtd_recebida = qtd_recebida; data_update.qtd_atendida = qtd_atendida; data_update.qtd_fora_garantia = qtd_fora_garantia; data_update.qtd_outras_marcas = qtd_outras_marcas; data_update.qtd_faltante = qtd_faltante; data_update.qtd_avariada = qtd_avariada; data_update.qtd_descartada = qtd_descartada; data_update.conferido = isDelete ? "N" : "S"; db.Entry(data_update).State = EntityState.Modified; int TotalDeItens = db.GarantiaItem.Where(a => a.garantiaid == garantiaId).Count(); int TotalVerificado = db.GarantiaItem.Where(a => a.garantiaid == garantiaId).Where(c => c.conferido == "S").Count(); string asError = "ok_input"; if ((qtd_atendida + qtd_fora_garantia + qtd_outras_marcas + qtd_faltante + qtd_avariada + qtd_descartada) != qtd_recebida) { asError = "error_input"; } try { db.SaveChanges(); TotalVerificado = db.GarantiaItem.Where(a => a.garantiaid == garantiaId).Where(c => c.conferido == "S").Count(); return(Json(new { Msg = "Item Atualizado com sucesso", QtdeGarantia = TotalDeItens, QtdeVerificada = TotalVerificado, CError = asError, IDCERROR = "qtd_atendida" + garantiaitemid.ToString() })); } catch (Exception e) { return(Json(new { Msg = e.Message, QtdeGarantia = TotalDeItens, QtdeVerificada = TotalVerificado, CError = "", IDCERROR = "" })); } }
public ActionResult ConfirmItens(int garantiaId, int cod_cliente) { var AllItem = db.CartItem.Where(a => a.garantiaId == garantiaId).ToList(); if (AllItem == null) { return(RedirectToAction("Details", "Garantias", new { id = garantiaId })); } foreach (var a in AllItem) { int NextRecordId = db.Database.SqlQuery <int>(" SELECT GARANTIAITEM_SEQ.NextVal FROM DUAL ").FirstOrDefault(); GarantiaItem NewItem = new GarantiaItem() { cod_foxlux = a.cod_Foxlux.Trim().TrimEnd().TrimStart(), caminho_foto = null, cod_item = a.cod_item, garantiaid = a.garantiaId, garantiaitemid = NextRecordId, qtd_lancamento = a.qtde_Garantia, vlr_total = a.vlr_Unitario * a.qtde_Garantia, num_nota = a.num_nota, obs = "", justificativa = a.ObsItem, qtd_avariada = 0, qtd_faltante = 0, qtd_outras_marcas = 0, qtd_atendida = a.qtde_Garantia, qtd_descartada = 0, qtd_fora_garantia = 0, qtd_reaproveitada = 0, qtd_recebida = 0, qtd_rejeitada = 0, conferido = "N", vlr_lancamento = a.vlr_Unitario, vlr_ipi = a.vlr_ipi, vlr_icms = a.vlr_icms, vlr_base_subs = a.vlr_base_subs, vlr_icms_subs = a.vlr_icms_subs, picms = a.picms, pipi = a.pipi, picmsst = a.picmsst, mvast = (a.mvast > 0 ? a.mvast : 0), cod_unidade = a.cod_unidade }; db.GarantiaItem.Add(NewItem); } //altera e coloca o total da garantia try { db.SaveChanges(); AtualizaTotalGarantia(garantiaId); return(Json(new { id = garantiaId, Msg = "Ok, Redirecioando para detalhes...", hasError = false })); } catch (Exception e) { return(Json(new { id = garantiaId, Msg = e.Message, hasError = true })); } }