public async Task <List <TemplatePartModel> > GetTemplatePart(Filters.FilterModel filter)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@TemplatePartId", DBNull.Value);
sp.Add(param);
param = new SqlParameter("@CompId", ToDBNull(filter.CompId));
sp.Add(param);
return(await _context.Database.SqlQuery <TemplatePartModel>("USPTemplatePartDetail @TemplatePartId,@CompId", sp.ToArray()).ToListAsync());
}
public async Task <List <EmailHeaderFooterModel> > GetEmailHeaderFooters(Filters.FilterModel filter)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@EmailHeaderFooterId", DBNull.Value);
sp.Add(param);
param = new SqlParameter("@CompId", ToDBNull(filter.CompId));
sp.Add(param);
return(await _context.Database.SqlQuery <EmailHeaderFooterModel>("USPEmailHeaderFooterDetail @EmailHeaderFooterId,@CompId", sp.ToArray()).ToListAsync());
}
