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