internal static async Task <List <Tables.Localization.Page> > List(Guid pageId)
{
await using var cmd = new SqlCommand("[Localization].[GetPages]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@PageId", SqlDbType.UniqueIdentifier).Value = pageId;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetList <Tables.Localization.Page>(sda));
}
internal static async Task <List <Tables.Localization.Testimonial> > List(string site)
{
await using var cmd = new SqlCommand("[Localization].[GetTestimonialsForSite]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@Site", SqlDbType.NVarChar, 25).Value = site;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetList <Tables.Localization.Testimonial>(sda));
}
internal static async Task <List <Tables.dbo.Client> > List(string site)
{
await using var cmd = new SqlCommand("[dbo].[GetClients]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@Site", SqlDbType.NVarChar, 25).Value = site;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetList <Tables.dbo.Client>(sda));
}
internal static async Task <List <Tables.Upload.Client> > List(Guid?clientId)
{
await using var cmd = new SqlCommand("[Upload].[GetClients]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@ClientId", SqlDbType.UniqueIdentifier).Value = clientId;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetList <Tables.Upload.Client>(sda));
}
internal static async Task <List <Tables.dbo.Testimonial> > List(string site, bool approved)
{
await using var cmd = new SqlCommand("[dbo].[GetTestimonialsForSiteApproved]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@Site", SqlDbType.NVarChar, 25).Value = site;
cmd.Parameters.Add("@Approved", SqlDbType.UniqueIdentifier).Value = approved;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetList <Tables.dbo.Testimonial>(sda));
}