public int Add(CMSPage obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = INSERTCMSPage;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
parameterName.Value = obj.Name;
parameterName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterName);
SqlParameter parameterDescription = new SqlParameter(PN_DESCRIPTION, SqlDbType.NVarChar);
parameterDescription.Value = obj.Description;
parameterDescription.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDescription);
SqlParameter parameterKeyword = new SqlParameter(PN_KEYWORD, SqlDbType.NVarChar);
parameterKeyword.Value = obj.Keyword;
parameterKeyword.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterKeyword);
SqlParameter parameterMetTags = new SqlParameter(PN_METTAGS, SqlDbType.NVarChar);
parameterMetTags.Value = obj.MetTags;
parameterMetTags.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterMetTags);
SqlParameter parameterTemplateName = new SqlParameter(PN_TEMPLATENAME, SqlDbType.NVarChar);
parameterTemplateName.Value = obj.TemplateName;
parameterTemplateName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterTemplateName);
SqlParameter parameterType = new SqlParameter(PN_TYPE, SqlDbType.Int);
parameterType.Value = obj.Type;
parameterType.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterType);
SqlParameter pageContent = new SqlParameter(PN_PAGE_CONTENT, SqlDbType.NVarChar);
pageContent.Value = obj.PageContent;
pageContent.Direction = ParameterDirection.Input;
_command.Parameters.Add(pageContent);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
private void DeletePageforUpdate(CMSPage _page)
{
try
{
File.Delete(Server.MapPath("~/UserPages/" + _page.Name));
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
private void WriteNewPage(CMSPage _page)
{
//Read Sample File
string samplepagecontent = UtilitiesManager.ReadFile(Server.MapPath("~/UserPages/SamplePage.txt"));
samplepagecontent = samplepagecontent.Replace("#TemplateName#", _page.TemplateName);
UtilitiesManager.WriteFile(Server.MapPath("~/UserPages/" + _page.Name), samplepagecontent, false, false);
}
private void EditMode()
{
if (ObjectID > 0)
{
CMSPage page = new CMSPage();
page = CMSPageManager.GetByID(ObjectID);
if (null == page)
return;
txtName.Text = page.Name;
txtMetaTags.Text = page.MetTags;
txtKeywords.Text = page.Keyword;
txtDesc.Text = page.Description;
ddlTemplateName.SelectedValue = page.TemplateName;
plcControls.Visible = true;
}
}
void btnSaveUpdate_Click(object sender, EventArgs e)
{
CMSPage page = new CMSPage();
if (ObjectID <= 0)
{
try
{
page.Name = txtName.Text;
if (!page.Name.Contains(".aspx"))
{
page.Name += ".aspx";
}
page.Description = txtDesc.Text;
page.Keyword = txtKeywords.Text;
page.MetTags = txtMetaTags.Text;
page.TemplateName = ddlTemplateName.SelectedValue;
page.Type = DataLayer.Enums.RootEnums.PageType.User;
page.PageContent = string.Empty;
DeletePageforUpdate(page);
WriteNewPage(page);
CMSPageManager.Add(page);
AddMode();
dvProblems.InnerText = "Saved Successfully";
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
else
{
try
{
page = CMSPageManager.GetByID(ObjectID);
if (null == page)
{
dvProblems.InnerText = Resources.ExpressCMS.ResourceManager.GetString(ConstantsManager.UnknowErronOccures);
return;
}
page.Name = txtName.Text;
if (!page.Name.Contains(".aspx"))
{
page.Name += ".aspx";
}
page.Description = txtDesc.Text;
page.Keyword = txtKeywords.Text;
page.TemplateName = ddlTemplateName.SelectedValue;
page.MetTags = txtMetaTags.Text;
page.Type = DataLayer.Enums.RootEnums.PageType.User;
page.PageContent = string.Empty;
DeletePageforUpdate(page);
WriteNewPage(page);
CMSPageManager.Update(page);
EditMode();
dvProblems.InnerText = "Saved Successfully";
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
BindGrid();
}
public void PopulateCMSPage(SqlDataReader _dtr, CMSPage obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.CN_DESCRIPTION);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Description = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.CN_KEYWORD);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Keyword = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.CN_METTAGS);
if (!_dtr.IsDBNull(columnIndex))
{
obj.MetTags = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.CN_TEMPLATENAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.TemplateName = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.CN_TYPE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.PageType)_dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CMSPageDataMapper.PN_PAGE_CONTENT);
if (!_dtr.IsDBNull(columnIndex))
{
obj.PageContent = _dtr.GetString((columnIndex));
}
}
public static void Update(CMSPage obj)
{
CMSPageDataMapper objCaller = new CMSPageDataMapper();
objCaller.Update(obj);
}
public static int Add(CMSPage obj)
{
CMSPageDataMapper objCaller = new CMSPageDataMapper();
return objCaller.Add(obj);
}
public CMSPage GetCMSPage(SqlDataReader _dtr, IList<CMSPage> colobj)
{
CMSPage obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new CMSPage();
colobj.Add(obj);
}
return obj;
}
public IList<CMSPage> GetAll()
{
CMSPage obj = null;
IList<CMSPage> colobj = new List<CMSPage>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLCMSPage;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new CMSPage();
colobj = new List<CMSPage>();
while (_dtreader.Read())
{
obj = GetCMSPage(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
private void GetEntityFromReader(SqlDataReader _dtr, CMSPage obj)
{
PopulateCMSPage(_dtr, obj);
}
public CMSPage GetByID(int ID)
{
CMSPage obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTCMSPage;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(CN_ID, SqlDbType.Int);
parameterID.Value = ID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new CMSPage();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}