public void Delete(int id)
{
MatchUrls_DeleteByHelpId(id);
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.FirstTimeHelp_Delete;
command.Parameters.Add(new SqlParameter("@id", id));
connection.Open();
command.ExecuteNonQuery();
}
}
public void Create(FirstTimeHelp help)
{
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.FirstTimeHelp_Create;
AddParameters(help, command);
connection.Open();
help.Id = (int)command.ExecuteScalar();
}
MatchUrls_CreateByHelpId(help.Id, help.MatchUrls);
}
public IEnumerable <DocumentationPage> ReadAll()
{
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.DocumentationPage_ReadAll;
connection.Open();
var reader = command.ExecuteReader();
foreach (var page in HydratePages(reader))
{
yield return(page);
}
}
}
public IEnumerable <Bullet> ReadAll()
{
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.Bullet_ReadAll;
connection.Open();
var reader = command.ExecuteReader();
foreach (var bullet in HydrateBullets(reader))
{
yield return(bullet);
}
}
}
public IEnumerable <FirstTimeHelp> ReadAll()
{
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.FirstTimeHelp_ReadAll;
connection.Open();
var reader = command.ExecuteReader();
foreach (var help in HydratePages(reader))
{
yield return(help);
}
}
}
public void DeleteExcept(List <int> pageIds)
{
if (null == pageIds || pageIds.Count == 0)
{
return;
}
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.DocumentationPage_DeleteExcept.Replace("@pageIds", pageIds.ToCsv());
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(FirstTimeHelp help)
{
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.FirstTimeHelp_Update;
AddParameters(help, command);
command.Parameters.Add(new SqlParameter("@id", help.Id));
connection.Open();
command.ExecuteNonQuery();
}
MatchUrls_DeleteByHelpId(help.Id);
MatchUrls_CreateByHelpId(help.Id, help.MatchUrls);
}
public List <DocumentationPage> ReadByParentId(int?parentId)
{
List <DocumentationPage> result = null;
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.DocumentationPage_ReadByParentId;
command.Parameters.Add(new SqlParameter("@parentId", (object)parentId ?? DBNull.Value));
connection.Open();
using (var reader = command.ExecuteReader())
{
result = new List <DocumentationPage>(HydratePages(reader));
}
}
return(result ?? new List <DocumentationPage>());
}
public DocumentationPage Read(int id)
{
DocumentationPage result = null;
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.DocumentationPage_ReadById;
command.Parameters.Add(new SqlParameter("@id", id));
connection.Open();
using (var reader = command.ExecuteReader())
{
result = HydratePages(reader).FirstOrDefault();
}
}
return(result);
}
public List <Bullet> ReadByPageId(int pageId)
{
List <Bullet> result;
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.Bullet_ReadByPageId;
command.Parameters.Add(new SqlParameter("@pageId", pageId));
connection.Open();
using (var reader = command.ExecuteReader())
{
result = new List <Bullet>(HydrateBullets(reader));
}
}
return(result);
}
public FirstTimeHelp ReadByUrl(string url)
{
FirstTimeHelp result = null;
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.FirstTimeHelp_ReadByUrl;
command.Parameters.Add(new SqlParameter("@url", url));
connection.Open();
using (var reader = command.ExecuteReader())
{
result = HydratePages(reader).FirstOrDefault();
}
}
return(result);
}
public UserPageSettings Read(string userName, int pageId)
{
UserPageSettings result = null;
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.UserPageSettings_ReadByUserAndPage;
command.Parameters.AddRange(new SqlParameter[] {
new SqlParameter("@userName", userName),
new SqlParameter("@pageId", pageId)
});
connection.Open();
using (var reader = command.ExecuteReader())
{
result = HydrateUserPageSettings(reader).FirstOrDefault();
}
}
return(result);
}
public List <DocumentationPage> ReadTableOfContents(bool includeHidden)
{
var result = new List <DocumentationPage>();
using (var connection = SqlConnectionFactory.GetConnection())
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.DocumentationPage_ReadTableOfContents;
command.Parameters.Add(new SqlParameter("@includeHidden", includeHidden));
connection.Open();
using (var reader = command.ExecuteReader())
{
var idOrdinal = reader.GetOrdinal("Id");
var parentPageIdOrdinal = reader.GetOrdinal("ParentPageId");
var orderOrdinal = reader.GetOrdinal("Order");
var titleOrdinal = reader.GetOrdinal("Title");
var isHiddenOrdinal = reader.GetOrdinal("IsHidden");
while (reader.Read())
{
result.Add(new DocumentationPage
{
Id = reader.GetInt32(idOrdinal),
ParentPageId = reader.IsDBNull(parentPageIdOrdinal) ? (int?)null : reader.GetInt32(parentPageIdOrdinal),
Order = reader.GetInt32(orderOrdinal),
Title = reader.GetString(titleOrdinal),
IsHidden = reader.GetBoolean(isHiddenOrdinal),
});
}
}
}
return(result);
}
private void MatchUrls_CreateByHelpId(int helpId, string matchUrls)
{
if (!string.IsNullOrEmpty(matchUrls))
{
var pageUrls = matchUrls.Trim().Split(' ');
using (var connection = SqlConnectionFactory.GetConnection())
{
connection.Open();
foreach (var pageUrl in pageUrls)
{
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = SqlScripts.PageUrl_Create;
command.Parameters.Add(new SqlParameter("@url", pageUrl.Replace('*', '%')));
command.Parameters.Add(new SqlParameter("@pageId", helpId));
command.ExecuteNonQuery();
}
}
}
}
}