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