/// <summary>
/// Connects to database and adds modules details.
/// </summary>
/// <param name="objList">Object of ModuleInfo.</param>
/// <param name="isAdmin">Set true if the module is admin.</param>
/// <param name="PackageID">Package ID.</param>
/// <param name="IsActive">Set true if the module is active.</param>
/// <param name="AddedOn">Module added date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Module added user's name.</param>
/// <returns>Returns array of int containing 1: ModuleID and 2: ModuleDefID.</returns>
public int[] AddModules(ModuleInfo objList, bool isAdmin, int PackageID, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
string sp = "[dbo].[sp_ModulesAdd]";
//SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleName", objList.ModuleName));
ParamCollInput.Add(new KeyValuePair<string, object>("@Name", objList.Name));
ParamCollInput.Add(new KeyValuePair<string, object>("@FriendlyName", objList.FriendlyName));
ParamCollInput.Add(new KeyValuePair<string, object>("@Description", objList.Description));
ParamCollInput.Add(new KeyValuePair<string, object>("@FolderName", objList.FolderName));
ParamCollInput.Add(new KeyValuePair<string, object>("@Version", objList.Version));
ParamCollInput.Add(new KeyValuePair<string, object>("@isPremium", objList.isPremium));
ParamCollInput.Add(new KeyValuePair<string, object>("@isAdmin", isAdmin));
ParamCollInput.Add(new KeyValuePair<string, object>("@Owner", objList.Owner));
ParamCollInput.Add(new KeyValuePair<string, object>("@Organization", objList.Organization));
ParamCollInput.Add(new KeyValuePair<string, object>("@URL", objList.URL));
ParamCollInput.Add(new KeyValuePair<string, object>("@Email", objList.Email));
ParamCollInput.Add(new KeyValuePair<string, object>("@ReleaseNotes", objList.ReleaseNotes));
ParamCollInput.Add(new KeyValuePair<string, object>("@License", objList.License));
ParamCollInput.Add(new KeyValuePair<string, object>("@PackageType", objList.PackageType));
ParamCollInput.Add(new KeyValuePair<string, object>("@supportedFeatures", objList.supportedFeatures));
ParamCollInput.Add(new KeyValuePair<string, object>("@BusinessControllerClass", objList.BusinessControllerClass));
ParamCollInput.Add(new KeyValuePair<string, object>("@CompatibleVersions", objList.CompatibleVersions));
ParamCollInput.Add(new KeyValuePair<string, object>("@dependencies", objList.dependencies));
ParamCollInput.Add(new KeyValuePair<string, object>("@permissions", objList.permissions));
ParamCollInput.Add(new KeyValuePair<string, object>("@PackageID", PackageID));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
List<KeyValuePair<string, object>> ParamCollOutput = new List<KeyValuePair<string, object>>();
ParamCollOutput.Add(new KeyValuePair<string, object>("@ModuleID", objList.ModuleID));
ParamCollOutput.Add(new KeyValuePair<string, object>("@ModuleDefID", objList.ModuleDefID));
SageFrameSQLHelper sagesql = new SageFrameSQLHelper();
List<KeyValuePair<int, string>> OutputValColl = new List<KeyValuePair<int, string>>();
OutputValColl = sagesql.ExecuteNonQueryWithMultipleOutput(sp, ParamCollInput, ParamCollOutput);
int[] arrOutPutValue = new int[2];
arrOutPutValue[0] = int.Parse(OutputValColl[0].Value);
arrOutPutValue[1] = int.Parse(OutputValColl[1].Value);
return arrOutPutValue;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds module permission
/// </summary>
/// <param name="ModuleDefID">Module's definition ID.</param>
/// <param name="PermissionID">Permission ID.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="PortalModuleID">Portal module ID.</param>
/// <param name="AllowAccess">Set true if the user is allowed access to this module.</param>
/// <param name="Username">User's name.</param>
/// <param name="IsActive">Set true if the permission is active.</param>
/// <param name="AddedOn">Permission added date</param>
/// <param name="AddedBy">Permission added user's name.</param>
/// <returns>Returns array of int containing 1:ModuleDefPermissionID and 2:PortalModulePermissionID.</returns>
public int[] AddModulePermission(int? ModuleDefID, int? PermissionID, int? PortalID, int? PortalModuleID, bool AllowAccess, string Username, bool IsActive, DateTime AddedOn, string AddedBy)
{
string sp = "[dbo].[sp_ModulesPermissionAdd]";
SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleDefID", ModuleDefID));
ParamCollInput.Add(new KeyValuePair<string, object>("@PermissionID", PermissionID));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalModuleID", PortalModuleID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AllowAccess", AllowAccess));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", Username));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
//int ListID = sagesql.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@ModuleDefPermissionID");
//return ListID;
ModuleInfo objInfo = new ModuleInfo();
List<KeyValuePair<string, object>> ParamCollOutput = new List<KeyValuePair<string, object>>();
ParamCollOutput.Add(new KeyValuePair<string, object>("@ModuleDefPermissionID", objInfo.ModuleDefPermissionID));
ParamCollOutput.Add(new KeyValuePair<string, object>("@PortalModulePermissionID", objInfo.PortalModulePermissionID));
SageFrameSQLHelper objHelper = new SageFrameSQLHelper();
List<KeyValuePair<int, string>> OutputValColl = new List<KeyValuePair<int, string>>();
OutputValColl = objHelper.ExecuteNonQueryWithMultipleOutput(sp, ParamCollInput, ParamCollOutput);
int[] arrOutPutValue = new int[2];
arrOutPutValue[0] = int.Parse(OutputValColl[0].Value);
arrOutPutValue[1] = int.Parse(OutputValColl[1].Value);
return arrOutPutValue;
}
catch (Exception)
{
throw;
}
}
public string AddUserModule(UserModuleInfo module)
{
SageFrameSQLHelper sqlH = new SageFrameSQLHelper();
SqlTransaction tran = (SqlTransaction)sqlH.GetTransaction();
try
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>
{
new KeyValuePair<string, object>(
"@ModuleDefID", module.ModuleDefID),
new KeyValuePair<string, object>(
"@UserModuleTitle", module.UserModuleTitle),
new KeyValuePair<string, object>(
"@AllPages", module.AllPages),
new KeyValuePair<string, object>(
"@ShowInPages", module.ShowInPages),
new KeyValuePair<string, object>(
"@InheritViewPermissions", module.InheritViewPermissions),
new KeyValuePair<string, object>(
"@IsActive", module.IsActive),
new KeyValuePair<string, object>(
"@AddedOn", DateTime.Now),
new KeyValuePair<string, object>(
"@PortalID", module.PortalID),
new KeyValuePair<string, object>(
"@AddedBy", module.PortalID),
new KeyValuePair<string, object>(
"@SEOName", module.SEOName),
new KeyValuePair<string,object>(
"@IsHandheld",module.IsHandheld),
new KeyValuePair<string,object>(
"@SuffixClass",module.SuffixClass),
new KeyValuePair<string,object>(
"@HeaderText",module.HeaderText),
new KeyValuePair<string,object>(
"@ShowHeaderText",module.ShowHeaderText),
new KeyValuePair<string,object>(
"@IsInAdmin",module.IsInAdmin)
};
List<KeyValuePair<string, object>> ParaMeterInputCollection = new List<KeyValuePair<string, object>>
{
new KeyValuePair<string, object>(
"@UserModuleID", 0),
new KeyValuePair<string, object>(
"@ControlCount", 0)
};
List<KeyValuePair<int, string>> resultColl = new List<KeyValuePair<int, string>>();
resultColl = sqlH.ExecuteNonQueryWithMultipleOutput(tran, CommandType.StoredProcedure, "[dbo].[usp_UserModulesAdd]", ParaMeterCollection, ParaMeterInputCollection);
if (int.Parse(resultColl[0].Value) > 0)
{
if (module.InheritViewPermissions)
{
//if (module.IsInAdmin)
//{
// module.PortalID = -1;
//}
SetUserModuleInheritedPermission(module.PageID, tran, int.Parse(resultColl[0].Value), module.PortalID, module.AddedBy, module.ModuleDefID);
}
else
{
SetUserModulePermission(module.LSTUserModulePermission, tran, int.Parse(resultColl[0].Value), module.PortalID, module.AddedBy, module.ModuleDefID);
}
if(module.IsInAdmin)
{
module.PortalID = -1;
}
SetPageModules(module, tran, int.Parse(resultColl[0].Value), module.PortalID, module.AddedBy);
}
tran.Commit();
return (string.Format("{0}_{1}", resultColl[0].Value.ToString(), resultColl[1].Value.ToString()));
}
catch (SqlException sqlEx)
{
tran.Rollback();
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
}