public void createClientPermissions(string userName, string ConnectionString)
{
UserPermissions UserPermissions = UserPermission.SelectByField("UserName", userName, ConnectionString);
if (UserPermissions.Count == 0)
{
UserPermission objUserPer = new UserPermission(ConnectionString);
objUserPer.IsMList = true;
objUserPer.IsList = true;
objUserPer.IsContact = true;
objUserPer.IsImport = true;
objUserPer.IsSegments = true;
objUserPer.IsDownloadContacts = true;
objUserPer.IsMCampaigns = true;
objUserPer.IsMailing = true;
objUserPer.IsCampaigns = true;
objUserPer.IsTemplates = true;
objUserPer.IsAgedCampaigns = true;
objUserPer.IsMAdvanced = true;
objUserPer.IsMangeFields = true;
objUserPer.IsMergeLists = true;
objUserPer.IsSuppressAddress = true;
objUserPer.IsBounceSettings = true;
objUserPer.IsMActivity = true;
objUserPer.IsAccountActivity = true;
objUserPer.IsCompareCampaign = true;
objUserPer.IsBounceReport = true;
objUserPer.IsMCampReports = true;
objUserPer.IsDashboard = true;
objUserPer.IsContactActivity = true;
objUserPer.IsClickPerformance = true;
objUserPer.IsAdvancedReports = true;
objUserPer.IsMicrositeManager = false;
objUserPer.IsCustomizedAMMForms = false;
objUserPer.IsAMMAdvanceReprot = false;
objUserPer.MasterLogo = null;
objUserPer.ChildLogo = null;
objMembershipUser = Membership.GetUser(userName);
objUserPer.UserName = userName;
objUserPer.UserId = (Guid)objMembershipUser.ProviderUserKey;
bool status = objUserPer.Insert();
}
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="UserPermissionPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class UserPermission</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 7/5/2012 11:05:31 AM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static UserPermission SelectOne(UserPermissionPrimaryKey pk, string ConnectionString)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);
bool ExecutionState = false;
// Pass the values of all key parameters to the stored procedure.
System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues();
foreach (string key in nvc.Keys)
{
oDatabaseHelper.AddParameter("@" + key,nvc[key] );
}
// The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);
IDataReader dr=oDatabaseHelper.ExecuteReader("sp_UserPermissions_SelectbyPrimaryKey", ref ExecutionState);
if (dr.Read())
{
UserPermission obj = new UserPermission(ConnectionString);
PopulateObjectFromReader(obj,dr);
dr.Close();
oDatabaseHelper.Dispose();
return obj;
}
else
{
dr.Close();
oDatabaseHelper.Dispose();
return null;
}
}
/// <summary>
/// Populates the fields for multiple objects from the columns found in an open reader.
/// </summary>
///
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <returns>Object of UserPermissions</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 7/5/2012 11:05:31 AM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static UserPermissions PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper, string ConnectionString)
{
UserPermissions list = new UserPermissions();
if (rdr.Read())
{
UserPermission obj = new UserPermission(ConnectionString);
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new UserPermission(ConnectionString);
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
}
oDatabaseHelper.Dispose();
return list;
}
else
{
oDatabaseHelper.Dispose();
return null;
}
}
/// <summary>
/// Populates the fields for multiple objects from the columns found in an open reader.
/// </summary>
///
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <returns>Object of UserPermissions</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 7/5/2012 11:05:31 AM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static UserPermissions PopulateObjectsFromReader(IDataReader rdr, string ConnectionString)
{
UserPermissions list = new UserPermissions();
while (rdr.Read())
{
UserPermission obj = new UserPermission(ConnectionString);
PopulateObjectFromReader(obj,rdr);
list.Add(obj);
}
return list;
}
/// <summary>
/// Create User in UserPermissions Table
/// </summary>
/// <param name="userName"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool insertUserInPermissionsTb(string userName,object userId)
{
bool status = false;
try
{
//First Get all Permissions of Client for User
UserPermissions objClientPer = UserPermission.SelectByField("UserName",User.Identity.Name.ToString(), ConnectionString);
//Add the Clent Permission to User For first Time
UserPermission objUserPer = new UserPermission(ConnectionString);
objUserPer.IsMList = (bool)objClientPer[0].IsMList;
objUserPer.IsList = objClientPer[0].IsList;
objUserPer.IsContact = objClientPer[0].IsContact;
objUserPer.IsImport = objClientPer[0].IsImport;
objUserPer.IsSegments = objClientPer[0].IsSegments;
objUserPer.IsDownloadContacts = objClientPer[0].IsDownloadContacts;
objUserPer.IsMCampaigns = objClientPer[0].IsMCampaigns;
objUserPer.IsMailing =objClientPer[0].IsMailing;
objUserPer.IsCampaigns = objClientPer[0].IsCampaigns;
objUserPer.IsTemplates = objClientPer[0].IsTemplates;
objUserPer.IsAgedCampaigns = objClientPer[0].IsAgedCampaigns;
objUserPer.IsMAdvanced = objClientPer[0].IsMAdvanced;
objUserPer.IsMangeFields = objClientPer[0].IsMangeFields;
objUserPer.IsMergeLists =objClientPer[0].IsMergeLists;
objUserPer.IsSuppressAddress = objClientPer[0].IsSuppressAddress;
objUserPer.IsBounceSettings = false;
objUserPer.IsMActivity =objClientPer[0].IsMActivity;
objUserPer.IsAccountActivity =objClientPer[0].IsAccountActivity;
objUserPer.IsCompareCampaign =objClientPer[0].IsCompareCampaign;
objUserPer.IsBounceReport = objClientPer[0].IsBounceReport;
objUserPer.IsMCampReports =objClientPer[0].IsMCampReports;
objUserPer.IsDashboard =objClientPer[0].IsDashboard;
objUserPer.IsContactActivity =objClientPer[0].IsContactActivity;
objUserPer.IsClickPerformance =objClientPer[0].IsClickPerformance;
objUserPer.IsAdvancedReports = objClientPer[0].IsAdvancedReports;
objUserPer.IsMicrositeManager = objClientPer[0].IsMicrositeManager;
objUserPer.IsCustomizedAMMForms = objClientPer[0].IsCustomizedAMMForms;
objUserPer.IsAMMAdvanceReprot =objClientPer[0].IsAMMAdvanceReprot;
objUserPer.ChildLogo = null;
objUserPer.MasterLogo = null;
objUserPer.UserId = (Guid)userId;
objUserPer.UserName = userName;
status = objUserPer.Insert();
}
catch (Exception ex)
{
}
return status;
}
public bool generateAccCls(string userName, string mode)
{
bool status = false;
try
{
objUserPer = new UserPermission(ConnectionString);
objUserPer.IsMList = RTAccountSettings.Nodes[0].Checked;
objUserPer.IsList = RTAccountSettings.Nodes[0].Nodes[0].Checked;
objUserPer.IsContact = RTAccountSettings.Nodes[0].Nodes[1].Checked;
objUserPer.IsImport = RTAccountSettings.Nodes[0].Nodes[2].Checked;
objUserPer.IsSegments = RTAccountSettings.Nodes[0].Nodes[3].Checked;
objUserPer.IsDownloadContacts = RTAccountSettings.Nodes[0].Nodes[4].Checked;
objUserPer.IsMCampaigns = RTAccountSettings.Nodes[1].Checked;
objUserPer.IsMailing = RTAccountSettings.Nodes[1].Nodes[0].Checked;
objUserPer.IsCampaigns = RTAccountSettings.Nodes[1].Nodes[1].Checked;
objUserPer.IsTemplates = RTAccountSettings.Nodes[1].Nodes[2].Checked;
objUserPer.IsAgedCampaigns = RTAccountSettings.Nodes[1].Nodes[3].Checked;
objUserPer.IsMAdvanced = RTAccountSettings.Nodes[2].Checked;
objUserPer.IsMangeFields = RTAccountSettings.Nodes[2].Nodes[0].Checked;
objUserPer.IsMergeLists = RTAccountSettings.Nodes[2].Nodes[1].Checked;
objUserPer.IsSuppressAddress = RTAccountSettings.Nodes[2].Nodes[2].Checked;
objUserPer.IsBounceSettings = RTAccountSettings.Nodes[2].Nodes[3].Checked;
objUserPer.IsMActivity = RTAccountSettings.Nodes[3].Checked;
objUserPer.IsAccountActivity = RTAccountSettings.Nodes[3].Nodes[0].Checked;
objUserPer.IsCompareCampaign = RTAccountSettings.Nodes[3].Nodes[1].Checked;
objUserPer.IsBounceReport = RTAccountSettings.Nodes[3].Nodes[2].Checked;
objUserPer.IsMCampReports = RTAccountSettings.Nodes[4].Checked;
objUserPer.IsDashboard = RTAccountSettings.Nodes[4].Nodes[0].Checked;
objUserPer.IsContactActivity = RTAccountSettings.Nodes[4].Nodes[1].Checked;
objUserPer.IsClickPerformance = RTAccountSettings.Nodes[4].Nodes[2].Checked;
objUserPer.IsAdvancedReports = RTAccountSettings.Nodes[4].Nodes[3].Checked;
objUserPer.IsMicrositeManager = RTAccountSettings.Nodes[5].Checked;
objUserPer.IsCustomizedAMMForms = RTAccountSettings.Nodes[6].Checked;
objUserPer.IsAMMAdvanceReprot = RTAccountSettings.Nodes[7].Checked;
objUserPer.MasterLogo = null;
if (LogoFileUpload.HasFile)
{
//Written By Swaroop Feb 15,2012 LogoFileUpload
System.IO.Stream streamContent = LogoFileUpload.PostedFile.InputStream;
picbyte = new byte[streamContent.Length];
MemoryStream ms = new MemoryStream(picbyte);
LogoFileUpload.PostedFile.InputStream.Read(picbyte, 0, picbyte.Length);
objUserPer.ChildLogo = picbyte;
}
else
{
if (ViewState["Logo"] != null)
objUserPer.ChildLogo = (byte[])ViewState["Logo"];
}
objMembershipUser = Membership.GetUser(userName);
objUserPer.UserName = userName;
objUserPer.UserId = (Guid)objMembershipUser.ProviderUserKey;
if (mode == "Insert")
status = objUserPer.Insert();
else
status = objUserPer.Update();
poplateTreeView(ddlUsers.SelectedItem.Text);
}
catch (Exception ex)
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = ex.Message;
}
return status;
}
public bool updateAllUserPermissions(string userName)
{
bool status = false;
try
{
UserPermissions objClientPer = UserPermission.SelectByField("UserName", ddlClients.SelectedItem.Text.ToString(), ConnectionString);
//First Get the UserPermissions.
UserPermissions UserPermissions = UserPermission.SelectByField("UserName", userName, ConnectionString);
if (UserPermissions.Count != 0)
{
objUserPer = new UserPermission(ConnectionString);
objUserPer.IsMList = (!(bool)objClientPer[0].IsMList) ? false : UserPermissions[0].IsMList;
objUserPer.IsList = (!(bool)objClientPer[0].IsList) ? false : UserPermissions[0].IsList;
objUserPer.IsContact = (!(bool)objClientPer[0].IsContact) ? false : UserPermissions[0].IsContact;
objUserPer.IsImport = (!(bool)objClientPer[0].IsImport) ? false : UserPermissions[0].IsImport;
objUserPer.IsSegments = (!(bool)objClientPer[0].IsSegments) ? false : UserPermissions[0].IsSegments;
objUserPer.IsDownloadContacts = (!(bool)objClientPer[0].IsDownloadContacts) ? false : UserPermissions[0].IsDownloadContacts;
objUserPer.IsMCampaigns = (!(bool)objClientPer[0].IsMCampaigns) ? false : UserPermissions[0].IsMCampaigns;
objUserPer.IsMailing = (!(bool)objClientPer[0].IsMailing) ? false : UserPermissions[0].IsMailing;
objUserPer.IsCampaigns = (!(bool)objClientPer[0].IsCampaigns) ? false : UserPermissions[0].IsCampaigns;
objUserPer.IsTemplates = (!(bool)objClientPer[0].IsTemplates) ? false : UserPermissions[0].IsTemplates;
objUserPer.IsAgedCampaigns = (!(bool)objClientPer[0].IsAgedCampaigns) ? false : UserPermissions[0].IsAgedCampaigns;
objUserPer.IsMAdvanced = (!(bool)objClientPer[0].IsMAdvanced) ? false : UserPermissions[0].IsMAdvanced;
objUserPer.IsMangeFields = (!(bool)objClientPer[0].IsMangeFields) ? false : UserPermissions[0].IsMangeFields;
objUserPer.IsMergeLists = (!(bool)objClientPer[0].IsMergeLists) ? false : UserPermissions[0].IsMergeLists;
objUserPer.IsSuppressAddress = (!(bool)objClientPer[0].IsSuppressAddress) ? false : UserPermissions[0].IsSuppressAddress;
objUserPer.IsBounceSettings = (!(bool)objClientPer[0].IsBounceSettings) ? false : UserPermissions[0].IsBounceSettings;
objUserPer.IsMActivity = (!(bool)objClientPer[0].IsMActivity) ? false : UserPermissions[0].IsMActivity;
objUserPer.IsAccountActivity = (!(bool)objClientPer[0].IsAccountActivity) ? false : UserPermissions[0].IsAccountActivity;
objUserPer.IsCompareCampaign = (!(bool)objClientPer[0].IsCompareCampaign) ? false : UserPermissions[0].IsCompareCampaign;
objUserPer.IsBounceReport = (!(bool)objClientPer[0].IsBounceReport) ? false : UserPermissions[0].IsBounceReport;
objUserPer.IsMCampReports = (!(bool)objClientPer[0].IsMCampReports) ? false : UserPermissions[0].IsMCampReports;
objUserPer.IsDashboard = (!(bool)objClientPer[0].IsDashboard) ? false : UserPermissions[0].IsDashboard;
objUserPer.IsContactActivity = (!(bool)objClientPer[0].IsContactActivity) ? false : UserPermissions[0].IsContactActivity;
objUserPer.IsClickPerformance = (!(bool)objClientPer[0].IsClickPerformance) ? false : UserPermissions[0].IsClickPerformance;
objUserPer.IsAdvancedReports = (!(bool)objClientPer[0].IsAdvancedReports) ? false : UserPermissions[0].IsAdvancedReports;
objUserPer.IsMicrositeManager = (!(bool)objClientPer[0].IsMicrositeManager) ? false : UserPermissions[0].IsMicrositeManager;
objUserPer.IsCustomizedAMMForms = (!(bool)objClientPer[0].IsCustomizedAMMForms) ? false : UserPermissions[0].IsCustomizedAMMForms;
objUserPer.IsAMMAdvanceReprot = (!(bool)objClientPer[0].IsAMMAdvanceReprot) ? false : UserPermissions[0].IsAMMAdvanceReprot;
objUserPer.ChildLogo = UserPermissions[0].ChildLogo;
objUserPer.MasterLogo = UserPermissions[0].MasterLogo;
objUserPer.UserId = (Guid)UserPermissions[0].UserId;
objUserPer.UserName = UserPermissions[0].UserName;
status = objUserPer.Update();
}
}
catch (Exception ex)
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = ex.Message;
}
return status;
}