public static DataTable GetLinksByPage(int siteId, int pageId)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ItemID", typeof(int));
dataTable.Columns.Add("ModuleID", typeof(int));
dataTable.Columns.Add("ModuleTitle", typeof(string));
dataTable.Columns.Add("Title", typeof(string));
dataTable.Columns.Add("Description", typeof(string));
dataTable.Columns.Add("ViewRoles", typeof(string));
dataTable.Columns.Add("CreatedDate", typeof(DateTime));
using (IDataReader reader = DBLinks.GetLinksByPage(siteId, pageId))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["ItemID"] = reader["ItemID"];
row["ModuleID"] = reader["ModuleID"];
row["ModuleTitle"] = reader["ModuleTitle"];
row["Title"] = reader["Title"];
row["Description"] = reader["Description"];
row["ViewRoles"] = reader["ViewRoles"];
row["CreatedDate"] = Convert.ToDateTime(reader["CreatedDate"]);
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
private bool Create()
{
int newID = -1;
this.itemGuid = Guid.NewGuid();
newID = DBLinks.AddLink(
this.itemGuid,
this.moduleGuid,
this.moduleID,
this.title,
this.url,
this.viewOrder,
this.description,
this.createdDate,
this.createdByUser,
this.target,
this.userGuid);
this.itemID = newID;
bool result = (newID > 0);
//IndexHelper.IndexItem(this);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
private void GetLink(Int32 itemId)
{
using (IDataReader reader = DBLinks.GetLink(itemId))
{
if (reader.Read())
{
this.itemID = Convert.ToInt32(reader["ItemID"], CultureInfo.InvariantCulture);
this.moduleID = Convert.ToInt32(reader["ModuleID"], CultureInfo.InvariantCulture);
this.createdByUser = Convert.ToInt32(reader["CreatedBy"], CultureInfo.InvariantCulture);
this.createdDate = Convert.ToDateTime(reader["CreatedDate"], CultureInfo.CurrentCulture);
this.title = reader["Title"].ToString();
this.url = reader["Url"].ToString();
this.viewOrder = Convert.ToInt32(reader["ViewOrder"]);
this.description = reader["Description"].ToString();
this.target = reader["Target"].ToString();
string test = reader["ItemGuid"].ToString();
this.itemGuid = new Guid(reader["ItemGuid"].ToString());
this.moduleGuid = new Guid(reader["ModuleGuid"].ToString());
string user = reader["UserGuid"].ToString();
if (user.Length == 36)
{
this.userGuid = new Guid(user);
}
}
}
}
private bool Create()
{
string content = string.Empty;
int newID = -1;
this.itemGuid = Guid.NewGuid();
if (this.ContentItems.Count < 1)
{
otherSettings.Content = this.content;
otherSettings.CssClass = this.cssClass;
otherSettings.MobileCssClass = this.mobileCssClass;
otherSettings.FeaturedImage = this.featuredImage;
try
{
content = Json.Encode(otherSettings);
}
catch (System.ArgumentException ex)
{
content = this.content;
}
}
else
{
try
{
content = JsonConvert.SerializeObject(this.ContentItems);
}
catch (JsonSerializationException ex)
{
content = this.content;
}
}
newID = DBLinks.AddLink(
this.itemGuid,
this.moduleGuid,
this.moduleID,
this.title,
this.url,
this.viewOrder,
content,
this.createdDate,
this.createdByUser,
this.target,
this.userGuid);
this.itemID = newID;
bool result = (newID > 0);
//IndexHelper.IndexItem(this);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
public static IDataReader GetPage(
int moduleId,
int pageNumber,
int pageSize,
out int totalPages)
{
return(DBLinks.GetPage(moduleId, pageNumber, pageSize, out totalPages));
}
public static List <SuperFlexiItem> GetModuleItems(Int32 moduleId)
{
string content = string.Empty;
List <SuperFlexiItem> items = new List <SuperFlexiItem>();
using (IDataReader reader = DBLinks.GetLinks(moduleId))
{
while (reader.Read())
{
SuperFlexiItem item = new SuperFlexiItem();
item.itemID = Convert.ToInt32(reader["ItemID"], CultureInfo.InvariantCulture);
item.moduleID = Convert.ToInt32(reader["ModuleID"], CultureInfo.InvariantCulture);
item.createdByUser = Convert.ToInt32(reader["CreatedBy"], CultureInfo.InvariantCulture);
item.createdDate = Convert.ToDateTime(reader["CreatedDate"], CultureInfo.CurrentCulture);
item.title = reader["Title"].ToString();
item.url = reader["Url"].ToString();
item.viewOrder = Convert.ToInt32(reader["ViewOrder"]);
content = reader["Description"].ToString();
OtherSettings others = ParseOtherSettings(content);
if (others != null)
{
item.content = others.Content;
item.cssClass = others.CssClass;
item.mobileCssClass = others.MobileCssClass;
item.featuredImage = others.FeaturedImage;
}
else
{
try
{
item.contentItems = JsonConvert.DeserializeObject <List <ContentItem> >(content);
}
catch (JsonSerializationException ex)
{
item.content = content;
}
}
item.target = reader["Target"].ToString();
//string test = reader["ItemGuid"].ToString();
item.itemGuid = new Guid(reader["ItemGuid"].ToString());
item.moduleGuid = new Guid(reader["ModuleGuid"].ToString());
string user = reader["UserGuid"].ToString();
if (user.Length == 36)
{
item.userGuid = new Guid(user);
}
items.Add(item);
}
}
return(items);
}
private void GetItem(Int32 itemId)
{
string content = string.Empty;
using (IDataReader reader = DBLinks.GetLink(itemId))
{
if (reader.Read())
{
this.itemID = Convert.ToInt32(reader["ItemID"], CultureInfo.InvariantCulture);
this.moduleID = Convert.ToInt32(reader["ModuleID"], CultureInfo.InvariantCulture);
this.createdByUser = Convert.ToInt32(reader["CreatedBy"], CultureInfo.InvariantCulture);
this.createdDate = Convert.ToDateTime(reader["CreatedDate"], CultureInfo.CurrentCulture);
this.title = reader["Title"].ToString();
this.url = reader["Url"].ToString();
this.viewOrder = Convert.ToInt32(reader["ViewOrder"]);
content = reader["Description"].ToString();
this.target = reader["Target"].ToString();
string test = reader["ItemGuid"].ToString();
this.itemGuid = new Guid(reader["ItemGuid"].ToString());
this.moduleGuid = new Guid(reader["ModuleGuid"].ToString());
string user = reader["UserGuid"].ToString();
if (user.Length == 36)
{
this.userGuid = new Guid(user);
}
}
}
OtherSettings others = ParseOtherSettings(content);
if (others != null)
{
this.content = others.Content;
this.cssClass = others.CssClass;
this.mobileCssClass = others.MobileCssClass;
this.featuredImage = others.FeaturedImage;
}
else
{
try
{
this.contentItems = JsonConvert.DeserializeObject <List <ContentItem> >(content);
}
catch (JsonSerializationException ex)
{
this.content = content;
}
}
}
public bool Delete()
{
bool result = DBLinks.DeleteLink(itemID);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
e.IsDeleted = true;
OnContentChanged(e);
}
return(result);
}
private bool Update()
{
bool result = DBLinks.UpdateLink(
this.itemID,
this.moduleID,
this.title,
this.url,
this.viewOrder,
this.description,
this.createdDate,
this.target,
this.createdByUser);
//IndexHelper.IndexItem(this);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
public static bool DeleteBySite(int siteId)
{
return(DBLinks.DeleteBySite(siteId));
}
public static bool DeleteByModule(int moduleId)
{
return(DBLinks.DeleteByModule(moduleId));
}
public static IDataReader GetLinks(Int32 moduleId)
{
return(DBLinks.GetLinks(moduleId));
}
