public ActionResult UpdateModules(List <QAUtil.Models.Modules> grid, FormCollection form)
{
int churchId = Convert.ToInt32(form["church"]);
ViewData["churchId"] = churchId;
ViewData["dataSource"] = form["dataSource"];
var dataContext = new ModulesDataContext(Common.FetchDBConnectionString(form["dataSource"]));
foreach (var item in grid)
{
bool enabled = item.ENABLED;
int module_id = item.MODULE_ID;
// Enable or disable the module
if (enabled)
{
if (!dataContext.CHURCH_MODULEs.Any(c => c.MODULE_ID == item.MODULE_ID && c.CHURCH_ID == churchId))
{
CHURCH_MODULE cm = new CHURCH_MODULE()
{
CHURCH_ID = churchId,
MODULE_ID = item.MODULE_ID,
CREATED_DATE = DateTime.Now,
LAST_UPDATED_DATE = DateTime.Now,
CREATED_BY_LOGIN = HttpContext.User.Identity.Name
};
dataContext.CHURCH_MODULEs.InsertOnSubmit(cm);
dataContext.SubmitChanges();
}
}
else
{
if (dataContext.CHURCH_MODULEs.Any(c => c.MODULE_ID == item.MODULE_ID && c.CHURCH_ID == churchId))
{
dataContext.CHURCH_MODULEs.DeleteOnSubmit(dataContext.CHURCH_MODULEs.Where(cm => cm.MODULE_ID == item.MODULE_ID && cm.CHURCH_ID == churchId).Select(cm => cm).Single());
dataContext.SubmitChanges();
}
}
}
return(RedirectToAction("Modules", new { dataSource = ViewData["dataSource"], churchId = ViewData["churchId"] }));
}
private void detach_CHURCH_MODULEs(CHURCH_MODULE entity)
{
this.SendPropertyChanging();
entity.MODULE = null;
}
partial void DeleteCHURCH_MODULE(CHURCH_MODULE instance);
private void attach_CHURCH_MODULEs(CHURCH_MODULE entity)
{
this.SendPropertyChanging();
entity.MODULE = this;
}
partial void UpdateCHURCH_MODULE(CHURCH_MODULE instance);
partial void InsertCHURCH_MODULE(CHURCH_MODULE instance);
