Message IManterMONEY_COUNT.Salvar(Money_Count moneyCount) { Message msg = new Message(); try { using (var contexto = new Dominio.Entidades.HostelEntities()) { if (moneyCount.ID != 0) { contexto.Entry(moneyCount).State = EntityState.Modified; } else { contexto.Money_Count.Add(moneyCount); } contexto.SaveChanges(); } } catch (Exception ex) { msg.Exception = ex; } return(msg); }
public ActionResult Create([Bind(Include = "TotalCalc, IDCalc_Type, Qnt_1_Cent, Qnt_2_Cents, Qnt_5_Cents, Qnt_10_Cents, Qnt_20_Cents, Qnt_20_Cents, Qnt_50_Cents, Qnt_1_Euro, Qnt_2_Euros, Qnt_5_Euros, Qnt_10_Euros, Qnt_10_Euros, Qnt_20_Euros, Qnt_50_Euros, Qnt_100_Euros, Qnt_200_Euros, Qnt_500_Euros, TotalMoney_Count")] TelaCalc calcView) { if (ModelState.IsValid) { var IDCalc_Type = Convert.ToString(Request["IDCalc_Type"]); var moneyCount = new Money_Count(); moneyCount.Qnt_1_Cent = calcView.Qnt_1_Cent; moneyCount.Qnt_2_Cents = calcView.Qnt_2_Cents; moneyCount.Qnt_5_Cents = calcView.Qnt_5_Cents; moneyCount.Qnt_10_Cents = calcView.Qnt_10_Cents; moneyCount.Qnt_20_Cents = calcView.Qnt_20_Cents; moneyCount.Qnt_50_Cents = calcView.Qnt_50_Cents; moneyCount.Qnt_1_Euro = calcView.Qnt_1_Euro; moneyCount.Qnt_2_Euros = calcView.Qnt_2_Euros; moneyCount.Qnt_5_Euros = calcView.Qnt_5_Euros; moneyCount.Qnt_10_Euros = calcView.Qnt_10_Euros; moneyCount.Qnt_20_Euros = calcView.Qnt_20_Euros; moneyCount.Qnt_50_Euros = calcView.Qnt_50_Euros; moneyCount.Qnt_100_Euros = calcView.Qnt_100_Euros; moneyCount.Qnt_200_Euros = calcView.Qnt_200_Euros; moneyCount.Qnt_500_Euros = calcView.Qnt_500_Euros; moneyCount.ID_Calc_Type = calcView.IDCalc_Type; moneyCount.DT_Reg = DateTime.UtcNow.AddSeconds(1); moneyCount.LogLogin = (User != null && User.Identity != null && !string.IsNullOrEmpty(User.Identity.Name)) ? User.Identity.Name : string.Empty; moneyCount.Total = calcView.TotalMoney_Count; var msg = Fachada.Negocio.ManterMONEY_COUNT.Salvar(moneyCount); if (msg.Result != Message.ResultType.Success) { return(Content(msg.Description)); } var calc = new Calc(); calc.Total = GetTotalToCalc(); calc.DT_reg = DateTime.UtcNow; calc.LogLogin = (User != null && User.Identity != null && !string.IsNullOrEmpty(User.Identity.Name)) ? User.Identity.Name : string.Empty; calc.ID_Money_Count = moneyCount.ID; List <int> idsCalcType = (from a in db.Calc_Type where a.ID != calcView.IDCalc_Type select a.ID).ToList(); List <int> idsMoneyCount = new List <int>(); for (int i = 0; i < idsCalcType.Count; i++) { int idActual = idsCalcType[i]; idsMoneyCount.Add((from a in db.Money_Count orderby a.DT_Reg descending where a.ID_Calc_Type == idActual select a.ID).FirstOrDefault()); } if (idsMoneyCount.Count > 0 && idsMoneyCount[0] > 0) { calc.ID_Money_Count2 = idsMoneyCount[0]; } if (idsMoneyCount.Count > 1 && idsMoneyCount[1] > 0) { calc.ID_Money_Count3 = idsMoneyCount[1]; } var msgSaveCalc = Fachada.Negocio.ManterCALC.Salvar(calc); if (msgSaveCalc.Result != Message.ResultType.Success) { return(Content(msgSaveCalc.Description)); } if (msg.Result == Message.ResultType.Success) { return(RedirectToAction("Index")); } else { return(Content("Erro ao Salvar " + msg.Description + "")); } } else { carregaCombos(); return(View()); } }