/// <summary>
/// Променя данните за страницата
/// </summary>
public void SetPage(int siteID, SPageModel page)
{
// HTML Page
if (page.TypeID == 1)
{
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{
command.CommandText =
@"UPDATE S_PAGES
SET PAGE_NAME = " + ParameterString(page.Name) + @"
, PAGE_TITLE = " + ParameterString(page.Title) + @"
, PAGE_VALUE = " + ParameterString(page.Value) + @"
WHERE ID = " + ParameterInt(page.ID) + @"
AND SITE_ID = " + ParameterInt(siteID);
command.ExecuteNonQuery();
}
}
// MVC Page & MVC Layout
else
{
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{
command.CommandText =
@"UPDATE S_PAGES
SET PAGE_NAME = " + ParameterString(page.Name) + @"
, PAGE_TITLE = " + ParameterString(page.Title) + @"
WHERE ID = " + ParameterInt(page.ID) + @"
AND SITE_ID = " + ParameterInt(siteID);
command.ExecuteNonQuery();
}
string pagePath = GetPagePath(page.Name);
WriterCSHTML(pagePath, page.Value);
}
}
/// <summary>
/// Основни данни за нова страницата
/// </summary>
public SPageModel GetNewPage(int siteID, int typePage)
{
SPageModel page = null;
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{
command.CommandText =
@"SELECT pgt.ID AS PAGE_TYPE_ID
, pgt.PAGE_TYPE_NAME
, upt.S_PAGE_TYPE_EDITOR_ID
FROM S_PAGE_TYPES pgt
LEFT JOIN U_PAGE_TYPE_EDITOR upt
ON upt.S_PAGE_TYPE_ID = pgt.ID
AND upt.U_USER_ID = " + ParameterInt(HttpSession.UserID) + @"
WHERE pgt.ID = " + ParameterInt(typePage);
using (SQLiteDataReader dReader = command.ExecuteReader())
{
if (dReader.HasRows && dReader.Read())
{
page = new SPageModel
{
ID = 0,
SiteID = siteID,
TypeID = TryParse.ToInt32(dReader["PAGE_TYPE_ID"]),
TypeName = dReader["PAGE_TYPE_NAME"].ToString(),
TypeEditorID = TryParse.ToInt32(dReader["S_PAGE_TYPE_EDITOR_ID"])
};
}
else
{
page = new SPageModel
{
ID = 0,
SiteID = siteID,
TypeID = 1,
TypeName = "HTML Page",
TypeEditorID = 2 // Tinymce
};
}
}
}
// Само при редакция
if (page.ID > 0)
{
// MVC Page
if (page.TypeID == 2)
{
string pagePath = GetPagePath(page.SiteVeiw, page.Name);
page.Value = ReaderCSHTML(pagePath);
}
}
return(page);
}
/// <summary>
/// Основни данни за страницата
/// </summary>
public SPageModel GetPage(int siteID, int pageID)
{
SPageModel page = null;
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{
command.CommandText =
@"SELECT pg.ID
, pg.PAGE_NAME
, pg.PAGE_TITLE
, pg.PAGE_VALUE
, pg.PAGE_TYPE_ID
, pgt.PAGE_TYPE_NAME
, upt.S_PAGE_TYPE_EDITOR_ID
, st.VIEW_ID
FROM S_PAGES pg
INNER JOIN S_SITES st
ON st.ID = pg.SITE_ID
LEFT JOIN S_PAGE_TYPES pgt
ON pgt.ID = pg.PAGE_TYPE_ID
LEFT JOIN U_PAGE_TYPE_EDITOR upt
ON upt.S_PAGE_TYPE_ID = pg.PAGE_TYPE_ID
AND upt.U_USER_ID = " + ParameterInt(HttpSession.UserID) + @"
WHERE pg.ID = " + ParameterInt(pageID) + @"
AND pg.SITE_ID = " + ParameterInt(siteID);
using (SQLiteDataReader dReader = command.ExecuteReader())
{
if (dReader.HasRows && dReader.Read())
{
page = new SPageModel
{
ID = pageID,
SiteID = siteID,
Name = dReader["PAGE_NAME"].ToString(),
Title = dReader["PAGE_TITLE"].ToString(),
Value = dReader["PAGE_VALUE"].ToString(),
TypeID = TryParse.ToInt32(dReader["PAGE_TYPE_ID"]),
TypeName = dReader["PAGE_TYPE_NAME"].ToString(),
TypeEditorID = TryParse.ToInt32(dReader["S_PAGE_TYPE_EDITOR_ID"]),
SiteVeiw = dReader["VIEW_ID"].ToString()
};
}
}
}
// MVC Page
if (page.TypeID == 2)
{
string pagePath = GetPagePath(page.SiteVeiw, page.Name);
page.Value = ReaderCSHTML(pagePath);
}
return(page);
}
/// <summary>
/// Добавя страница
/// </summary>
public void AddPage(int siteID, SPageModel page)
{
// HTML Page
if (page.TypeID == 1)
{
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{
command.CommandText =
@"INSERT INTO S_PAGES
( PAGE_NAME, PAGE_TITLE, PAGE_VALUE, SITE_ID, PAGE_TYPE_ID)
VALUES (" + ParameterString(page.Name) +
", " + ParameterString(page.Title) +
", " + ParameterString(page.Value) +
", " + ParameterInt(siteID) +
", " + ParameterInt(page.TypeID) + ")";
command.ExecuteNonQuery();
}
}
// MVC Page & MVC Layout
else
{
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{
command.CommandText =
@"INSERT INTO S_PAGES
( PAGE_NAME, PAGE_TITLE, SITE_ID, PAGE_TYPE_ID)
VALUES (" + ParameterString(page.Name) +
", " + ParameterString(page.Title) +
", " + ParameterInt(siteID) +
", " + ParameterInt(page.TypeID) + ")";
command.ExecuteNonQuery();
}
page.SiteVeiw = GetSiteVeiw(siteID);
string pagePath = GetPagePath(page.SiteVeiw, page.Name);
WriterCSHTML(pagePath, page.Value);
}
}