public void InsertModules(ExtractModuleInfo objExtract, int portalID, out string showInpages, out int newUserModuleID)
{
string roleName = "";
string allowAcess = "";
string permissionID = "";
foreach (TemplatePermission objPermission in objExtract.ModuleDef.UserModule.TemplatePermission)
{
allowAcess += objPermission.AllowAccess + ",";
roleName += objPermission.RoleName + ",";
permissionID += objPermission.PermissionID + ",";
}
SQLHandler sagesql = new SQLHandler();
//objExtract.ModuleDef.UserModule.ShowInPages;
List <KeyValuePair <string, object> > PageParamCollModule = new List <KeyValuePair <string, object> >();
PageParamCollModule.Add(new KeyValuePair <string, object>("@pageID", objExtract.ModuleDef.UserModule.PageID));
PageParamCollModule.Add(new KeyValuePair <string, object>("@ModuleName", objExtract.ModuleName));
PageParamCollModule.Add(new KeyValuePair <string, object>("@FriendlyName", objExtract.FriendlyName));
PageParamCollModule.Add(new KeyValuePair <string, object>("@userModuleTitle", objExtract.ModuleDef.FriendlyName));
PageParamCollModule.Add(new KeyValuePair <string, object>("@paneName", objExtract.ModuleDef.UserModule.PaneName));
PageParamCollModule.Add(new KeyValuePair <string, object>("@allowAcess", allowAcess));
PageParamCollModule.Add(new KeyValuePair <string, object>("@roleName", roleName));
PageParamCollModule.Add(new KeyValuePair <string, object>("@permissionID", permissionID));
PageParamCollModule.Add(new KeyValuePair <string, object>("@portalID", portalID));
PageParamCollModule.Add(new KeyValuePair <string, object>("@allPages", objExtract.ModuleDef.UserModule.AllPages));
PageParamCollModule.Add(new KeyValuePair <string, object>("@inheritViewPermissions", objExtract.ModuleDef.UserModule.InheritViewPermissions));
PageParamCollModule.Add(new KeyValuePair <string, object>("@header", objExtract.ModuleDef.UserModule.Header));
PageParamCollModule.Add(new KeyValuePair <string, object>("@footer", objExtract.ModuleDef.UserModule.Footer));
PageParamCollModule.Add(new KeyValuePair <string, object>("@isActive", objExtract.ModuleDef.UserModule.IsActive));
PageParamCollModule.Add(new KeyValuePair <string, object>("@seoName", objExtract.ModuleDef.UserModule.SEOName));
PageParamCollModule.Add(new KeyValuePair <string, object>("@ShowInPages", objExtract.ModuleDef.UserModule.ShowInPages));
PageParamCollModule.Add(new KeyValuePair <string, object>("@IsHandheld", objExtract.ModuleDef.UserModule.IsHandheld));
PageParamCollModule.Add(new KeyValuePair <string, object>("@suffixClass", objExtract.ModuleDef.UserModule.SuffixClass));
PageParamCollModule.Add(new KeyValuePair <string, object>("@headerText", objExtract.ModuleDef.UserModule.HeaderText));
PageParamCollModule.Add(new KeyValuePair <string, object>("@showHeaderText", objExtract.ModuleDef.UserModule.ShowHeaderText));
PageParamCollModule.Add(new KeyValuePair <string, object>("@isInAdmin", objExtract.ModuleDef.UserModule.IsInAdmin));
PageParamCollModule.Add(new KeyValuePair <string, object>("@query", objExtract.ModuleDef.UserModule.Query));
PageParamCollModule.Add(new KeyValuePair <string, object>("@level", objExtract.ModuleDef.UserModule.Level));
ExtractUserModule objUserModule = new ExtractUserModule();
try
{
objUserModule = sagesql.ExecuteAsObject <ExtractUserModule>("usp_Template_InsertModule ", PageParamCollModule);
newUserModuleID = objUserModule.UserModuleId;
showInpages = objExtract.ModuleDef.UserModule.ShowInPages;
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertModules(ExtractModuleInfo objExtract, int portalID, out string showInpages, out int newUserModuleID)
{
string roleName = "";
string allowAcess = "";
string permissionID = "";
foreach (TemplatePermission objPermission in objExtract.ModuleDef.UserModule.TemplatePermission)
{
allowAcess += objPermission.AllowAccess + ",";
roleName += objPermission.RoleName + ",";
permissionID += objPermission.PermissionID + ",";
}
SQLHandler sagesql = new SQLHandler();
//objExtract.ModuleDef.UserModule.ShowInPages;
List<KeyValuePair<string, object>> PageParamCollModule = new List<KeyValuePair<string, object>>();
PageParamCollModule.Add(new KeyValuePair<string, object>("@pageID", objExtract.ModuleDef.UserModule.PageID));
PageParamCollModule.Add(new KeyValuePair<string, object>("@ModuleName", objExtract.ModuleName));
PageParamCollModule.Add(new KeyValuePair<string, object>("@FriendlyName", objExtract.FriendlyName));
PageParamCollModule.Add(new KeyValuePair<string, object>("@userModuleTitle", objExtract.ModuleDef.FriendlyName));
PageParamCollModule.Add(new KeyValuePair<string, object>("@paneName", objExtract.ModuleDef.UserModule.PaneName));
PageParamCollModule.Add(new KeyValuePair<string, object>("@allowAcess", allowAcess));
PageParamCollModule.Add(new KeyValuePair<string, object>("@roleName", roleName));
PageParamCollModule.Add(new KeyValuePair<string, object>("@permissionID", permissionID));
PageParamCollModule.Add(new KeyValuePair<string, object>("@portalID", portalID));
PageParamCollModule.Add(new KeyValuePair<string, object>("@allPages", objExtract.ModuleDef.UserModule.AllPages));
PageParamCollModule.Add(new KeyValuePair<string, object>("@inheritViewPermissions", objExtract.ModuleDef.UserModule.InheritViewPermissions));
PageParamCollModule.Add(new KeyValuePair<string, object>("@header", objExtract.ModuleDef.UserModule.Header));
PageParamCollModule.Add(new KeyValuePair<string, object>("@footer", objExtract.ModuleDef.UserModule.Footer));
PageParamCollModule.Add(new KeyValuePair<string, object>("@isActive", objExtract.ModuleDef.UserModule.IsActive));
PageParamCollModule.Add(new KeyValuePair<string, object>("@seoName", objExtract.ModuleDef.UserModule.SEOName));
PageParamCollModule.Add(new KeyValuePair<string, object>("@ShowInPages", objExtract.ModuleDef.UserModule.ShowInPages));
PageParamCollModule.Add(new KeyValuePair<string, object>("@IsHandheld", objExtract.ModuleDef.UserModule.IsHandheld));
PageParamCollModule.Add(new KeyValuePair<string, object>("@suffixClass", objExtract.ModuleDef.UserModule.SuffixClass));
PageParamCollModule.Add(new KeyValuePair<string, object>("@headerText", objExtract.ModuleDef.UserModule.HeaderText));
PageParamCollModule.Add(new KeyValuePair<string, object>("@showHeaderText", objExtract.ModuleDef.UserModule.ShowHeaderText));
PageParamCollModule.Add(new KeyValuePair<string, object>("@isInAdmin", objExtract.ModuleDef.UserModule.IsInAdmin));
PageParamCollModule.Add(new KeyValuePair<string, object>("@query", objExtract.ModuleDef.UserModule.Query));
PageParamCollModule.Add(new KeyValuePair<string, object>("@level", objExtract.ModuleDef.UserModule.Level));
ExtractUserModule objUserModule = new ExtractUserModule();
try
{
objUserModule = sagesql.ExecuteAsObject<ExtractUserModule>("usp_Template_InsertModule ", PageParamCollModule);
newUserModuleID = objUserModule.UserModuleId;
showInpages = objExtract.ModuleDef.UserModule.ShowInPages;
}
catch (Exception ex)
{
throw ex;
}
}
// Extratracting ModuleList
List<ExtractModuleInfo> ModuleList(XmlNode page, DataSet objDataset)
{
List<ExtractModuleInfo> lstModules = new List<ExtractModuleInfo>();
XmlNodeList modulelist = page.SelectNodes("Module");
foreach (XmlNode module in modulelist)
{
ExtractModuleInfo m = new ExtractModuleInfo();
m.ModuleID = int.Parse(Utils.CleanString(module["ModuleID"].InnerText));
m.FriendlyName = Utils.CleanString(module["FriendlyName"].InnerText);
m.Description = Utils.CleanString(module["Description"].InnerText);
m.Version = Utils.CleanString(module["Version"].InnerText);
m.IsPremium = bool.Parse(Utils.CleanString(module["IsPremium"].InnerText));
m.IsAdmin = bool.Parse(Utils.CleanString(module["IsAdmin"].InnerText));
m.IsRequired = bool.Parse(Utils.CleanString(module["IsRequired"].InnerText));
m.BusinessControllerClass = Utils.CleanString(module["BusinessControllerClass"].InnerText);
m.FolderName = Utils.CleanString(module["FolderName"].InnerText);
m.ModuleName = Utils.CleanString(module["ModuleName"].InnerText);
m.SupportedFeatures = int.Parse(Utils.CleanString(module["SupportedFeatures"].InnerText));
m.CompatibleVersions = Utils.CleanString(module["CompatibleVersions"].InnerText);
m.Dependencies = Utils.CleanString(module["Dependencies"].InnerText);
m.PackageID = int.Parse(Utils.CleanString(module["PackageID"].InnerText));
m.IsActive = bool.Parse(Utils.CleanString(module["IsActive"].InnerText));
m.ModuleDef = ModuleDef(module["ModuleDef"], objDataset);
lstModules.Add(m);
}
return lstModules;
}