private async Task <IEnumerable <ProjectsModel> > GetItemsAsync()
{
try
{
using (IDbConnection conn = _connectionFactory.GetConnection())
{
var result = conn.QueryMultiple("GetProjectsWithImages",
new { @chapterid = Convert.ToInt32(_myconfigs.Value.ChapterId) },
commandType: CommandType.StoredProcedure);
var set0 = result.Read <ProjectCategoryModel>().ToList();
var set1 = result.Read <ProjectsModel>().ToList();
var set2 = result.Read <ProjectImageModel>().ToList();
foreach (var project in set0)
{
project.ProjectsModel = set1.Where(x => x.projectcategoryid == project.projectscategoryid).ToList();
foreach (var item in set1)
{
item.ProjectImageModel = set2.Where(x => x.projectsid == item.projectsid).ToList();
}
}
return(set1);
}
}
catch (Exception ex)
{
return(null);
}
}
private List <AlbumModel> GetItemsAsync()
{
try
{
using (IDbConnection conn = _connectionFactory.GetConnection())
{
if (!string.IsNullOrEmpty(_myconfigs.Value.ChapterId))
{
var result = conn.QueryMultiple("GetAlbumWithPictures",
new { @chapterid = Convert.ToInt32(_myconfigs.Value.ChapterId) },
commandType: CommandType.StoredProcedure);
var set1 = result.Read <AlbumModel>().ToList();
var set2 = result.Read <PicturesModel>().ToList();
foreach (var item in set1)
{
item.Pictures = set2.Where(x => x.albumid == item.albumId).ToList();
item.AllPictures = set2;
}
return(set1);
}
else
{
var result = conn.QueryMultiple("GetAlbumWithPictures",
new { @chapterid = 0 },
commandType: CommandType.StoredProcedure);
var set1 = result.Read <AlbumModel>().ToList();
var set2 = result.Read <PicturesModel>().ToList();
foreach (var item in set1)
{
item.Pictures = set2.Where(x => x.albumid == item.albumId).ToList();
item.AllPictures = set2;
}
return(set1);
}
}
}
catch (Exception ex)
{
return(null);
}
}
private IEnumerable <PastLeadersModel> GetItemsAsync()
{
try
{
using (IDbConnection conn = _connectionFactory.GetConnection())
{
if (!string.IsNullOrEmpty(_myconfigs.Value.ChapterId))
{
var result = conn.Query <PastLeadersModel>("select * from PastLeaders where ChapterId=" + _myconfigs.Value.ChapterId + " order by 1 desc");
return(result);
}
else
{
var result = conn.Query <PastLeadersModel>("select * from PastLeaders");
return(result);
}
}
}
catch (Exception ex)
{
return(null);
}
}
private IEnumerable <MemberModel> GetItemsAsync()
{
try
{
using (IDbConnection conn = _connectionFactory.GetConnection())
{
if (!string.IsNullOrEmpty(_myconfigs.Value.ChapterId))
{
var result = conn.Query <MemberModel>("select * from member where ChapterId=" + _myconfigs.Value.ChapterId + " and isBoardMember!=0 order by isBoardMember desc, firstname");
return(result);
}
else
{
var result = conn.Query <MemberModel>("select * from member where isBoardMember!=0");
return(result);
}
}
}
catch (Exception ex)
{
return(null);
}
}
private async Task <IEnumerable <BulletinModel> > GetItemsAsync()
{
try
{
using (IDbConnection conn = _connectionFactory.GetConnection())
{
if (!string.IsNullOrEmpty(_myconfigs.Value.ChapterId))
{
var result = conn.Query <BulletinModel>("select * from bulletin where ChapterId=" + _myconfigs.Value.ChapterId);
return(result);
}
else
{
var result = conn.Query <BulletinModel>("select * from bulletin");
return(result);
}
}
}
catch (Exception ex)
{
return(null);
}
}
private async Task <IEnumerable <EventsModel> > GetItemsAsync()
{
try
{
using (IDbConnection conn = _connectionFactory.GetConnection())
{
if (!string.IsNullOrEmpty(_myconfigs.Value.ChapterId))
{
var result = conn.Query <EventsModel>("select * from events where date>=convert(date,GETDATE(),102) and ChapterId=" + _myconfigs.Value.ChapterId + " order by date desc, time desc");
return(result);
}
else
{
var result = conn.Query <EventsModel>("select * from events");
return(result);
}
}
}
catch (Exception ex)
{
return(null);
}
}
private async Task <IEnumerable <PicturesModel> > GetItemsAsync()
{
try
{
using (IDbConnection conn = _connectionFactory.GetConnection())
{
if (!string.IsNullOrEmpty(_myconfigs.Value.ChapterId))
{
var result = conn.Query <PicturesModel>("select * from pictures p INNER JOIN album a on p.albumid=a.albumid where a.chapterid=" + _myconfigs.Value.ChapterId);
return(result);
}
else
{
var result = conn.Query <PicturesModel>("select * from pictures");
return(result);
}
}
}
catch (Exception ex)
{
return(null);
}
}
