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.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.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 <Tables.Log.Inquiry> Item(Guid?id)
{
await using var cmd = new SqlCommand("[Log].[GetInquiry]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@Id", SqlDbType.UniqueIdentifier).Value = id;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetItem <Tables.Log.Inquiry>(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));
}
internal static async Task <Tables.dbo.Client> Item(string emailAddress)
{
await using var cmd = new SqlCommand("[dbo].[GetClientByEmailAddress]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 256).Value = emailAddress;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetItem <Tables.dbo.Client>(sda));
}
internal static async Task <Tables.dbo.Image> DefaultTestimonial(string site)
{
await using var cmd = new SqlCommand("[dbo].[GetImageDefaultTestimonial]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@Site", SqlDbType.NVarChar, 25).Value = site;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetItem <Tables.dbo.Image>(sda));
}
internal static async Task <Tables.dbo.Testimonial> Item(Guid siteId, Guid workId)
{
await using var cmd = new SqlCommand("[dbo].[GetTestimonialBySiteIdWorkId]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@SiteId", SqlDbType.UniqueIdentifier).Value = siteId;
cmd.Parameters.Add("@WorkId", SqlDbType.UniqueIdentifier).Value = workId;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetItem <Tables.dbo.Testimonial>(sda));
}
internal static async Task <Tables.Upload.Client> Item(Guid?clientId, string originalFilename)
{
await using var cmd = new SqlCommand("[Upload].[GetClientByClientIdOriginalFilename]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@ClientId", SqlDbType.UniqueIdentifier).Value = clientId;
cmd.Parameters.Add("@OriginalFilename", SqlDbType.NVarChar, 256).Value = originalFilename;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetItem <Tables.Upload.Client>(sda));
}
internal static async Task <Tables.dbo.Image> Item(string site, string path)
{
await using var cmd = new SqlCommand("[dbo].[GetImageBySitePath]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@Site", SqlDbType.NVarChar, 25).Value = site;
cmd.Parameters.Add("@Path", SqlDbType.NVarChar, 4440).Value = path;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetItem <Tables.dbo.Image>(sda));
}
internal static async Task <Tables.dbo.Page> Item(string site, int areaId, string name)
{
await using var cmd = new SqlCommand("[dbo].[GetPageBySiteAreaIdName]", new Base().SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@Site", SqlDbType.NVarChar, 25).Value = site;
cmd.Parameters.Add("@AreaId", SqlDbType.Int).Value = areaId;
cmd.Parameters.Add("@Enum", SqlDbType.NVarChar, 50).Value = name;
using var sda = new SqlDataAdapter(cmd);
return(Object.GetItem <Tables.dbo.Page>(sda));
}
