/// <summary>
/// Fills the {0} from a OleIDataReader.
/// </summary>
public static void FillFromReader(DbContentRating dbContentRating, IDataReader r, int idOffset, int dataOffset)
{
dbContentRating.iD = r.GetInt32(idOffset);
dbContentRating.isSynced = true;
dbContentRating.isPlaceHolder = false;
dbContentRating.createDate = r.GetDateTime(0 + dataOffset);
dbContentRating.modifyDate = r.GetDateTime(1 + dataOffset);
dbContentRating.name = r.GetString(2 + dataOffset);
dbContentRating.description = r.GetString(3 + dataOffset);
dbContentRating.iconUrl = r.GetString(4 + dataOffset);
if (!r.IsDBNull(5 + dataOffset) && r.GetInt32(5 + dataOffset) > 0)
{
dbContentRating.requiredRole = GreyFoxRole.NewPlaceHolder(r.GetInt32(5 + dataOffset));
}
}
/// <summary>
/// Fills the {0} from a OleIDataReader.
/// </summary>
public static void FillFromReader(GreyFoxSetting greyFoxSetting, IDataReader r, int idOffset, int dataOffset)
{
greyFoxSetting.iD = r.GetInt32(idOffset);
greyFoxSetting.isSynced = true;
greyFoxSetting.isPlaceHolder = false;
greyFoxSetting.name = r.GetString(0 + dataOffset);
greyFoxSetting.settingValue = r.GetString(1 + dataOffset);
if (!r.IsDBNull(2 + dataOffset) && r.GetInt32(2 + dataOffset) > 0)
{
greyFoxSetting.parent = GreyFoxSetting.NewPlaceHolder(r.GetInt32(2 + dataOffset));
}
if (!r.IsDBNull(3 + dataOffset) && r.GetInt32(3 + dataOffset) > 0)
{
greyFoxSetting.modifyRole = GreyFoxRole.NewPlaceHolder(r.GetInt32(3 + dataOffset));
}
greyFoxSetting.isSystemSetting = r.GetBoolean(4 + dataOffset);
}
protected void ok_Click(object sender, EventArgs e)
{
if (dbContentRatingID == 0)
{
obj = new DbContentRating();
}
else
{
obj = new DbContentRating(dbContentRatingID);
}
obj.Name = tbName.Text;
obj.Description = tbDescription.Text;
obj.IconUrl = tbIconUrl.Text;
if (msRequiredRole.SelectedItem != null && msRequiredRole.SelectedItem.Value != "Null")
{
obj.RequiredRole = GreyFoxRole.NewPlaceHolder(
int.Parse(msRequiredRole.SelectedItem.Value));
}
else
{
obj.RequiredRole = null;
}
if (editOnAdd)
{
dbContentRatingID = obj.Save();
}
else
{
obj.Save();
}
if (resetOnAdd)
{
tbName.Text = string.Empty;
tbDescription.Text = string.Empty;
tbIconUrl.Text = string.Empty;
msRequiredRole.SelectedIndex = 0;
}
OnUpdated(EventArgs.Empty);
}
protected void ok_Click(object sender, EventArgs e)
{
if (greyFoxSettingID == 0)
{
obj = new GreyFoxSetting();
}
else
{
obj = new GreyFoxSetting(greyFoxSettingID);
}
obj.Name = tbName.Text;
obj.Value = tbValue.Text;
if (msModifyRole.SelectedItem != null && msModifyRole.SelectedItem.Value != "Null")
{
obj.ModifyRole = GreyFoxRole.NewPlaceHolder(
int.Parse(msModifyRole.SelectedItem.Value));
}
else
{
obj.ModifyRole = null;
}
if (editOnAdd)
{
greyFoxSettingID = obj.Save();
}
else
{
obj.Save();
}
if (resetOnAdd)
{
tbName.Text = string.Empty;
tbValue.Text = string.Empty;
msModifyRole.SelectedIndex = 0;
}
OnUpdated(EventArgs.Empty);
}
/// <summary>
/// Fills the {0} from a OleDbDataReader.
/// </summary>
public static void FillFromReader(GreyFoxSetting greyFoxSetting, OleDbDataReader r, int idOffset, int dataOffset)
{
greyFoxSetting.iD = r.GetInt32(idOffset);
greyFoxSetting.isSynced = true;
greyFoxSetting.isPlaceHolder = false;
//
// Parse Children From Database
//
if (!r.IsDBNull(0 + dataOffset) && r.GetInt32(0 + dataOffset) > 0)
{
greyFoxSetting.modifyRole = GreyFoxRole.NewPlaceHolder(r.GetInt32(0 + dataOffset));
}
//
// Parse Fields From Database
//
greyFoxSetting.name = r.GetString(1 + dataOffset);
greyFoxSetting.value = r.GetString(2 + dataOffset);
}
protected override void OnPreRender(EventArgs e)
{
if (loadFlag)
{
if (greyFoxRoleID > 0)
{
obj = new GreyFoxRole(greyFoxRoleID);
text = "Edit - " + obj.ToString();
}
else if (greyFoxRoleID <= 0)
{
obj = new GreyFoxRole();
text = "Add ";
}
//
// Set Field Entries
//
tbName.Text = obj.Name;
tbDescription.Text = obj.Description;
cbIsDisabled.Checked = obj.IsDisabled;
}
}
protected override void OnPreRender(EventArgs e)
{
if (loadFlag)
{
if (greyFoxRoleID != 0)
{
obj = new GreyFoxRole(greyFoxRoleID);
tbName.Text = obj.Name;
tbDescription.Text = obj.Description;
cbIsDisabled.Checked = obj.IsDisabled;
tabstrip.SelectedTab = tabstrip.Tabs[0];
headerText.Text = Localization.Strings.Edit +
Localization.PeopleStrings.Space +
obj.Name;
}
else
{
headerText.Text = Localization.Strings.Edit;
}
}
}
/// <summary>
/// Initializes the database with the necissary tables to support the content
/// manager as well as creating a default content catalog and associated roles
/// in the Amns.GreyFox user's database.
/// </summary>
/// <returns></returns>
public void Install()
{
OleDbConnection dbConnection = new OleDbConnection(dbConnectionString);
OleDbCommand dbCommand = new OleDbCommand();
OleDbTransaction dbTransaction;
dbCommand.Connection = dbConnection;
// Try to open database
try
{
dbConnection.Open();
dbTransaction = dbConnection.BeginTransaction();
}
catch (OleDbException e)
{
throw(new ContentManagerException(e.Message, e.ErrorCode));
}
// Try to create table to hold catalogs
try
{
//
dbCommand.CommandText = createCatalogTable;
dbCommand.Transaction = dbTransaction;
dbCommand.ExecuteNonQuery();
GreyFoxRole authorRole = new GreyFoxRole(dbConnectionString);
authorRole.Name = "CMS/Author";
authorRole.Description = "Default Author";
authorRole.IsDisabled = false;
authorRole.Save();
GreyFoxRole reviewerRole = new GreyFoxRole(dbConnectionString);
reviewerRole.Name = "CMS/Reviewer";
reviewerRole.Description = "Default Reviewer";
reviewerRole.IsDisabled = false;
reviewerRole.Save();
GreyFoxRole editorRole = new GreyFoxRole(dbConnectionString);
editorRole.Name = "CMS/Editor";
editorRole.Description = "Default CMS Editor";
editorRole.IsDisabled = false;
editorRole.Save();
GreyFoxRole publisherRole = new GreyFoxRole(dbConnectionString);
publisherRole.Name = "CMS/Publisher";
publisherRole.Description = "Default CMS Publisher";
publisherRole.IsDisabled = false;
GreyFoxRole adminRole = new GreyFoxRole(dbConnectionString);
adminRole.Name = "CMS/Admin";
adminRole.Description = "Default CMS Administrator";
adminRole.IsDisabled = false;
adminRole.Save();
iD = createCatalog(dbCommand);
dbTransaction.Commit();
sync = true;
}
catch (OleDbException e)
{
iD = 0;
dbTransaction.Rollback();
throw(new ContentManagerException(e.Message + " SQL: " + sqlStatement, e.ErrorCode));
}
finally
{
dbConnection.Close();
}
Log.InsertGenericEvent(DateTime.Now.ToUniversalTime(), ContentLogEntryType.CatalogCreateSuccess, iD);
}
protected void ok_Click(object sender, EventArgs e)
{
if (greyFoxUserID == 0)
{
obj = new GreyFoxUser();
}
else
{
obj = new GreyFoxUser(greyFoxUserID);
}
obj.UserName = tbUserName.Text;
obj.IsDisabled = cbIsDisabled.Checked;
obj.LoginDate = DateTime.Parse(tbLoginDate.Text);
obj.LoginCount = int.Parse(tbLoginCount.Text);
obj.LoginPassword = tbLoginPassword.Text;
obj.ActivationID = tbActivationID.Text;
if (msContact.SelectedItem != null && msContact.SelectedItem.Value != "Null")
{
obj.Contact = GreyFoxContact.NewPlaceHolder("sysGlobal_Contacts",
int.Parse(msContact.SelectedItem.Value));
}
else
{
obj.Contact = null;
}
if (msRoles.IsChanged)
{
obj.Roles = new GreyFoxRoleCollection();
foreach (ListItem i in msRoles.Items)
{
if (i.Selected)
{
obj.Roles.Add(GreyFoxRole.NewPlaceHolder(int.Parse(i.Value)));
}
}
}
if (editOnAdd)
{
greyFoxUserID = obj.Save();
}
else
{
obj.Save();
}
if (resetOnAdd)
{
tbUserName.Text = string.Empty;
cbIsDisabled.Checked = false;
tbLoginDate.Text = DateTime.Now.ToString();
tbLoginCount.Text = string.Empty;
tbLoginPassword.Text = string.Empty;
tbActivationID.Text = string.Empty;
msContact.SelectedIndex = 0;
}
OnUpdated(EventArgs.Empty);
}
