public void UpdatePosition(DBSectionModel section)
{
List <DBSectionModel> sections = new List <DBSectionModel>()
{
section
};
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
connection.Execute("WebsiteData.spPosition_Update @SectionID, @PageID, @Position, @DisplayTitle", sections);
}
}
public void UpdateSection(DBSectionModel section)
{
List <DBSectionModel> sections = new List <DBSectionModel>()
{
section
};
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
connection.Execute("WebsiteData.spSection_Update @SectionID, @Title, @Text", sections);
}
}
public ActionResult Delete(int pageID, int sectionID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
DBSectionModel section = db.SelectSection(sectionID);
if (section != null)
{
section.PageID = pageID;
return(View(ConvertSectionModel(section)));
}
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID }));
}
public ActionResult Display(int websiteID, int pageID, int sectionID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
DBSectionModel section = db.SelectSection(sectionID);
if (section != null)
{
section.PageID = pageID;
section.Text = MarkdownConverter.MarkdownToHTML(section.Text, websiteID);
return(View(ConvertSectionModel(section)));
}
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID }));
}
public ActionResult Edit(SectionModel section)
{
if (GetValid(section))
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
DBSectionModel dbSection = ConvertSectionModel(section);
db.UpdateSection(dbSection);
db.UpdatePosition(dbSection);
List <SectionLinkModel> links = MarkdownConverter.FindInternalLinks(section.Text, section.SectionID);
db.MergeSectionLinks(links, section.SectionID);
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID = section.PageID }));
}
return(View(section));
}
private SectionModel ConvertSectionModel(DBSectionModel section)
{
SectionModel convertedSection = new SectionModel()
{
PageID = section.PageID,
SectionID = section.SectionID,
DisplayTitle = section.DisplayTitle,
Text = section.Text,
Title = section.Title
};
int position;
int.TryParse(section.Position, out position);
convertedSection.Position = position;
return(convertedSection);
}
public int InsertSection(DBSectionModel section)
{
List <DBSectionModel> sections = new List <DBSectionModel>()
{
section
};
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
var parameters = new DynamicParameters();
parameters.Add("PageID", section.PageID);
parameters.Add("Title", section.Title);
parameters.Add("Text", section.Text);
parameters.Add("Position", section.Position);
parameters.Add("DisplayTitle", section.DisplayTitle);
parameters.Add("SectionID", dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Query <int>("WebsiteData.spSection_Insert", parameters, commandType: CommandType.StoredProcedure);
return(parameters.Get <int>("SectionID"));
}
}
