public ActionResult UpdatePaymentTypes(List <QAUtil.Models.PaymentTypes> grid, FormCollection form) { int churchId = Convert.ToInt32(form["church"]); int featureID = grid[0].FeatureID; ViewData["churchId"] = churchId; ViewData["dataSource"] = form["dataSource"]; var dataContext = new PaymentTypesDataContext(Common.FetchDBConnectionString(form["dataSource"])); foreach (var item in grid) { bool enabled = item.ENABLED; int pp_type_id = item.PP_TYPE_ID; // Enable or disable the module if (enabled) { if (!dataContext.PP_CHURCH_TYPE_PROCESSORs.Any(c => c.PP_TYPE_ID == item.PP_TYPE_ID && c.CHURCH_ID == churchId && c.FEATURE_ID == item.FeatureID)) { PP_CHURCH_TYPE_PROCESSOR cm = new PP_CHURCH_TYPE_PROCESSOR() { CHURCH_ID = churchId, PP_TYPE_ID = item.PP_TYPE_ID, FEATURE_ID = item.FeatureID, CREATED_DATE = DateTime.Now, LAST_UPDATED_DATE = DateTime.Now, CREATED_BY_LOGIN = HttpContext.User.Identity.Name, PP_Merchant_Provider_ID = item.PP_TYPE_ID == 19 ? 2 : 1 }; dataContext.PP_CHURCH_TYPE_PROCESSORs.InsertOnSubmit(cm); dataContext.SubmitChanges(); } } else { if (dataContext.PP_CHURCH_TYPE_PROCESSORs.Any(c => c.PP_TYPE_ID == item.PP_TYPE_ID && c.CHURCH_ID == churchId && c.FEATURE_ID == item.FeatureID)) { dataContext.PP_CHURCH_TYPE_PROCESSORs.DeleteOnSubmit(dataContext.PP_CHURCH_TYPE_PROCESSORs.Where(cm => cm.PP_TYPE_ID == item.PP_TYPE_ID && cm.CHURCH_ID == churchId && cm.FEATURE_ID == featureID).Select(cm => cm).Single()); dataContext.SubmitChanges(); } } } return(RedirectToAction("PaymentTypes", new { dataSource = ViewData["dataSource"], churchId = ViewData["churchId"], feature = featureID == 6 ? "Online Giving 1.0" : "Online Giving 2.0" })); }
private void detach_PP_CHURCH_TYPE_PROCESSORs(PP_CHURCH_TYPE_PROCESSOR entity) { this.SendPropertyChanging(); entity.PP_TYPE = null; }
partial void UpdatePP_CHURCH_TYPE_PROCESSOR(PP_CHURCH_TYPE_PROCESSOR instance);
partial void DeletePP_CHURCH_TYPE_PROCESSOR(PP_CHURCH_TYPE_PROCESSOR instance);
partial void InsertPP_CHURCH_TYPE_PROCESSOR(PP_CHURCH_TYPE_PROCESSOR instance);