public ActionResult _DealMaintenance(DealMaintenanceViewModel model) { if (ModelState.IsValid) { if (string.IsNullOrEmpty(model.DealCriteria)) { ModelState.AddModelError(string.Empty, "Criteria combination is required"); return(PartialView(model)); } var result = deal.SavePayeeDeal(model.PayeeDealKey, model.PayeeKey, model.DealCriteria, model.StatementDate, model.SubmitDate, model.CarrierID, model.ProductLine, model.ProductID, model.Wholesaler, model.BrokerDealer, model.Channel, model.Internal, model.ProducerID, model.MSA, model.Recruiter, model.MPPartner, model.WholesalerRole, model.PayeeGroup, model.CarrierAttribute, model.ProductAttribute, model.RecruiterAttribute, model.BrokerDealerAttribute, model.BrokerDealerInHierarchy, model.CalculationID, model.PayIndexKey, model.DeductionModel, model.LOA ? "Y" : "", model.Street ? "Y" : "", model.Directive, model.DealCap, model.CarrierLevel, model.VirtualCarrierLevel, model.ExpDelta, model.PctGross, model.PctPremium, model.PctOverride, model.PctCarrierLevel, model.PctWholesalerNet, model.RecruiterDebit, model.RecruiterCredit, model.ContingentBonus, model.YearEndBonus, model.Amount1, model.Amount2, model.Amount3, model.Rate1, model.Rate2, model.Rate3, model.Notes); if (result.Rows.Count > 0) { SetAlertViewBag(model.PayeeDealKey == 0 ? "Payee Deal added successfully." : "Changes to Payee Deal saved successfully.", AlertType.Success); model.PayeeDealKey = model.PayeeDealKey == 0 ? (int)result.Rows[0]["PayeeDealKey"] : model.PayeeDealKey; } else { SetAlertViewBag("Failed to save changes to Payee Deal.", AlertType.Failed); } } else { SetMaintainenceViewBag(model); return(PartialView("_DealDetails", model)); } return(RedirectToAction("_DealMaintenance", new { payeeDealKey = model.PayeeDealKey, payeeKey = model.PayeeKey })); }
// Set ViewBag items for Deal Maintenance Method // These viewbags contain data for dropdown lists for Deal Maintenance Page. private void SetMaintainenceViewBag(DealMaintenanceViewModel model) { // SECTION 1 (Deal Criteria) var criteriaCombo = new List <object>() { new { id = "CriteriaCombo", text = "disabled option", priority = 0, disabled = true } }; criteriaCombo.AddRange(deal.GetPayeeDealAttributes("criteriacombination").AsEnumerable().Select(c => new { id = c["DealCriteria"], text = c["DealCriteria"], priority = c["DealPriority"], active = c["Active"] })); ViewBag.dDealCriteria = criteriaCombo; //deal.GetPayeeDealAttributes("criteriacombination").ToSelectList("DealCriteria", "DealCriteria", model.DealCriteria); //Carrier Table Dropdown. var carrierCombo = new List <object>() { new { id = "CarrierCombo", text = "disabled option", disabled = true } }; carrierCombo.AddRange(deal.GetPayeeDealAttributes("carrier").AsEnumerable().Select(d => new { id = d["CarrierID"] != null ? d["CarrierID"].ToString().Trim() : "", text = d["Carrier"] != null ? d["Carrier"].ToString().Trim() : "", line = d["Line"] != null ? d["Line"].ToString().Trim() : "" }).ToList()); ViewBag.dCarrierCombination = carrierCombo; ViewBag.dCarrierAttribute = deal.GetPayeeDealAttributes("carrierattribute") .ToSelectList("AttributeID", "AttributeDescription", model.CarrierAttribute.ToString()); ViewBag.dProduct = deal.GetProductsForCarrierLine(model.CarrierID.HasValue ? model.CarrierID.Value : 0 , model.ProductLine.HasValue ? model.ProductLine.Value : 0).ToSelectList("ProductID", "Product", model.ProductID.ToString()); ViewBag.dProductAttribute = deal.GetPayeeDealAttributes("productattribute") .ToSelectList("AttributeID", "AttributeDescription", model.ProductAttribute.ToString()); ViewBag.dWholesaler = (model.DealCriteria ?? "").Contains("AFMO") ? deal.GetDealWholeSaler("AFMO").ToSelectList("Payee", "Payee", model.Wholesaler) : deal.GetDealWholeSaler("Wholesaler").ToSelectList("Payee", "Payee", model.Wholesaler); ViewBag.dBrokerDealer = deal.GetPayeeDealAttributes("brokerdealer").ToSelectList("Payee", "Payee", model.BrokerDealer); ViewBag.dBrokerDealerAttribute = deal.GetPayeeDealAttributes("brokerdealerattribute") .ToSelectList("AttributeID", "AttributeDescription", model.BrokerDealerAttribute.ToString()); ViewBag.BDInHierarchy = new SelectList(new List <SelectListItem> { new SelectListItem { Text = "Yes", Value = "Y" } }, "Value", "Text"); ViewBag.dChannel = deal.GetPayeeDealAttributes("channel").ToSelectList("Channel", "Channel", model.Channel); ViewBag.dInternal = deal.GetPayeeDealAttributes("internal").ToSelectList("Payee", "Payee", model.Internal); ViewBag.dProducer = deal.GetPayeeDealAttributes("producer").ToSelectList("ProducerID", "Producer", model.ProducerID.ToString()); ViewBag.dRecruiter = deal.GetPayeeDealAttributes("recruiter").ToSelectList("Recruiter", "Recruiter", model.Recruiter); ViewBag.dRecruiterAttribute = deal.GetPayeeDealAttributes("recruiterattribute") .ToSelectList("AttributeID", "AttributeDescription", model.RecruiterAttribute.ToString()); ViewBag.dMarketingProgram = deal.GetPayeeDealAttributes("MPPartner") .ToSelectList("MPPartner", "MPPartner", model.MPPartner); ViewBag.dPayeeGroup = deal.GetPayeeDealAttributes("payeegroup").ToSelectList("PayeeGroup", "PayeeGroup", model.PayeeGroup); //SECTION 2 (Deal Calculation) ViewBag.dCalculationCode = deal.GetCalculationCodeDetails(model.CalculationID).AsEnumerable().FirstOrDefault(); //Used for both Carrier Level and Virtual Carrier Level ViewBag.dCarrierLevel = deal.GetDealCarrierLevel(model.CarrierID, model.ProductLine) .ToSelectList("CarrierLevel", "CarrierLevel", model.CarrierLevel); ViewBag.dPayIndex = deal.GetPayeeDealAttributes("payindex").ToSelectList("PayIndexKey", "PayIndexKey", model.PayIndexKey); ViewBag.dDeductions = payee.GetLookupDeduction(model.PayeeType).ToSelectList("DeductionModel", "DeductionModel", model.DeductionModel); ViewBag.dDirective = deal.GetPayeeDealAttributes("directive").ToSelectList("Directive", "Directive", model.Directive); //ViewBag.CalCodeDesc = deal.GetPayeeDealAttributes("calculationcode"); ViewBag.CalCode = deal.GetCalCodeByParams(model.PayeeType ?? "", model.DealCriteria ?? "").AsEnumerable() .Select(p => new { id = p["CalculationID"], text = p["CalculationCode"], desc = p["CalculationDescription"], caljson = p["CalculationJSON"] }); }
public PartialViewResult _DealMaintenance(int payeeDealKey = 0, int payeeKey = 0) { DataSet payeeDeals = deal.GetPayeeDealbyKey(payeeDealKey); DealMaintenanceViewModel model = new DealMaintenanceViewModel(); var dsPayee = payee.GetPayeeDetailsByKey(payeeKey); if (dsPayee.Tables.Count < 1 || dsPayee.Tables[0].Rows.Count < 1) { return(PartialView("Error")); } DataRow payeeDetails = dsPayee.Tables[0].Rows[0]; model.PayeeType = payeeDetails["PayeeType"].ToString(); model.PayeeKey = payeeKey; if (payeeDeals != null && payeeDeals.Tables.Count > 0 && payeeDeals.Tables[0].Rows.Count > 0) { DataRow dr = payeeDeals.Tables[0].Rows[0]; //Criteria Section Properties model.PayeeDealKey = dr["PayeeDealKey"] is DBNull ? 0 : Convert.ToInt32(dr["PayeeDealKey"]); model.PayeeKey = dr["PayeeKey"] is DBNull ? 0 : Convert.ToInt32(dr["PayeeKey"]); model.DealCriteria = dr["DealCriteria"] is DBNull ? null : dr["DealCriteria"].ToString(); model.StatementDate = dr["StatementDate"] is DBNull ? (DateTime?)null : Convert.ToDateTime(dr["StatementDate"]); model.SubmitDate = dr["SubmitDate"] is DBNull ? (DateTime?)null : Convert.ToDateTime(dr["SubmitDate"]); model.CarrierID = dr["CarrierID"] is DBNull ? (int?)null : Convert.ToInt32(dr["CarrierID"]); model.Carrier = dr["Carrier"] is DBNull ? null : Convert.ToString(dr["Carrier"]); model.ProductLine = dr["ProductLine"] is DBNull ? (short?)null : Convert.ToInt16(dr["ProductLine"]); model.ProductID = dr["ProductID"] is DBNull ? (int?)null : Convert.ToInt32(dr["ProductID"]); model.Product = dr["Product"] is DBNull ? "" : dr["Product"].ToString(); model.Wholesaler = dr["Wholesaler"] is DBNull ? null : dr["Wholesaler"].ToString(); model.BrokerDealer = dr["BrokerDealer"] is DBNull ? null : dr["BrokerDealer"].ToString(); model.Channel = dr["Channel"] is DBNull ? null : dr["Channel"].ToString(); model.Internal = dr["Internal"] is DBNull ? null : dr["Internal"].ToString(); model.ProducerID = dr["ProducerID"] is DBNull ? (int?)null : Convert.ToInt32(dr["ProducerID"]); model.Producer = dr["Producer"] is DBNull ? "" : dr["Producer"].ToString(); model.Recruiter = dr["Recruiter"] is DBNull ? null : dr["Recruiter"].ToString(); model.MPPartner = dr["MPPartner"] is DBNull ? null : dr["MPPartner"].ToString(); model.WholesalerRole = dr["WholesalerRole"] is DBNull ? null : dr["WholesalerRole"].ToString(); model.PayeeGroup = dr["PayeeGroup"] is DBNull ? null : dr["PayeeGroup"].ToString(); model.CarrierAttribute = dr["CarrierAttributes"] is DBNull ? (int?)null : Convert.ToInt32(dr["CarrierAttributes"]); model.CarrierAttributeDescription = dr["CarrierAttributeDescription"] is DBNull ? "" : dr["CarrierAttributeDescription"].ToString(); model.ProductAttribute = dr["ProductAttributes"] is DBNull ? (int?)null : Convert.ToInt32(dr["ProductAttributes"]); model.ProductAttributeDescription = dr["ProductAttributeDescription"] is DBNull ? "" : dr["ProductAttributeDescription"].ToString(); model.RecruiterAttribute = dr["RecruiterAttributes"] is DBNull ? (int?)null : Convert.ToInt32(dr["RecruiterAttributes"]); model.RecruiterAttributeDescription = dr["RecruiterAttributeDescription"] is DBNull ? "" : dr["RecruiterAttributeDescription"].ToString(); model.BrokerDealerAttribute = dr["BrokerDealerAttributes"] is DBNull ? (int?)null : Convert.ToInt32(dr["BrokerDealerAttributes"]); model.BDAttributeDescription = dr["BDAttributeDescription"] is DBNull ? "" : dr["BDAttributeDescription"].ToString(); model.BrokerDealerInHierarchy = dr["BrokerDealerInHierarchy"] is DBNull ? null : Convert.ToString(dr["BrokerDealerInHierarchy"]); // Calculation Section Properties model.CalculationID = dr["CalculationID"] is DBNull ? null : Convert.ToString(dr["CalculationID"]); model.CalculationCode = dr["CalculationCode"] is DBNull ? null : Convert.ToString(dr["CalculationCode"]); model.PayIndexKey = dr["PayIndexKey"] is DBNull ? null : Convert.ToString(dr["PayIndexKey"]); model.DeductionModel = dr["DeductionModel"] is DBNull ? null : Convert.ToString(dr["DeductionModel"]); model.LOA = dr["LOA"] != null && Convert.ToString(dr["LOA"]) == "Y" ? true : false; model.Street = dr["Street"] != null && Convert.ToString(dr["Street"]) == "Y" ? true : false; model.ExpDelta = dr["ExpDelta"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["ExpDelta"]); model.Directive = dr["Directive"] is DBNull ? null : Convert.ToString(dr["Directive"]); model.DealCap = dr["DealCap"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["DealCap"]); model.CarrierLevel = dr["CarrierLevel"] is DBNull ? null : Convert.ToString(dr["CarrierLevel"]); model.VirtualCarrierLevel = dr["VirtualCarrierLevel"] is DBNull ? null : Convert.ToString(dr["VirtualCarrierLevel"]); model.PctGross = dr["PctGross"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["PctGross"]); model.PctPremium = dr["PctPremium"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["PctPremium"]); model.PctOverride = dr["PctOverride"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["PctOverride"]); model.PctCarrierLevel = dr["PctCarrierLevel"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["PctCarrierLevel"]); model.PctWholesalerNet = dr["PctWholesalerNet"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["PctWholesalerNet"]); model.RecruiterDebit = dr["RecruiterDebit"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["RecruiterDebit"]); model.RecruiterCredit = dr["RecruiterCredit"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["RecruiterCredit"]); model.ContingentBonus = dr["ContingentBonus"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["ContingentBonus"]); model.YearEndBonus = dr["YearEndBonus"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["YearEndBonus"]); model.Amount1 = dr["Amount1"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["Amount1"]); model.Amount2 = dr["Amount2"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["Amount2"]); model.Amount3 = dr["Amount3"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["Amount3"]); model.Rate1 = dr["Rate1"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["Rate1"]); model.Rate2 = dr["Rate2"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["Rate2"]); model.Rate3 = dr["Rate3"] is DBNull ? (decimal?)null : Convert.ToDecimal(dr["Rate3"]); model.Notes = dr["PayeeDealNotes"] is DBNull ? null : Convert.ToString(dr["PayeeDealNotes"]); //Check whether payee is published, in that case all of the modal has to be read only string isPublished = payeeDetails["Published"].ToString(); ViewBag.IsPayeePublished = isPublished; //Check if readonly view needs to be displayed //When user is readonly or payee is published and current user is not SuperUser if (userRole == (int)UserRole.ReadOnly || (isPublished == "Y" && userRole != (int)UserRole.SuperUser)) { return(PartialView("_MaintainenceReadOnly", model)); } } SetMaintainenceViewBag(model); return(PartialView("_DealDetails", model)); }
public JsonResult DeleteDeal(DealMaintenanceViewModel payeeMod) { return(Json(payee.DeletePayeeDeal(payeeMod.PayeeDealKey))); }