public List <CustomerSidePostModel> Posttable()
{
var res = new List <CustomerSidePostModel>();
PDBC db = new PDBC();
db.Connect();
DataTable dt = db.Select("SELECT [Id],[Title],[GroupId],[Text_min],[Text],(SELECT [ad_firstname]+ ' '+ [ad_lastname] as name FROM [tbl_ADMIN_main]where id_Admin=[WrittenBy_AdminId])as adminName ,[Date],[IsImportant],[Is_Deleted],[Is_Disabled],(SELECT [name]FROM [tbl_BLOG_Categories] where Id=[Cat_Id]) as Category,(SELECT [name]FROM [tbl_BLOG_Groups] where G_Id=[GroupId]) as GroupName,(SELECT top 1 B.PicAddress FROM [tbl_BLOG_Pic_Connector] as A inner join [tbl_ADMIN_UploadStructure_ImageAddress] as B on A.[PicId]=B.PicID where A.PostId=Id)as Pic FROM [tbl_BLOG_Post] order by(date)desc");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new CustomerSidePostModel()
{
Id = Convert.ToInt32(dt.Rows[i]["Id"]),
by = dt.Rows[i]["adminName"].ToString(),
Category = dt.Rows[i]["Category"].ToString(),
InGroup = dt.Rows[i]["GroupName"].ToString(),
ImagePath = dt.Rows[i]["Pic"].ToString(),
IsDeleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
IsDisabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
text = dt.Rows[i]["Text"].ToString(),
title = dt.Rows[i]["Title"].ToString(),
text_min = dt.Rows[i]["Text_min"].ToString(),
date = DateConvert.DateReturner(dt.Rows[i]["Date"].ToString(), "Date"),
GPIDforPostPAge = dt.Rows[i]["GroupId"].ToString()
};
res.Add(model);
}
return(res);
}
//public List<CustomerSidePostModel> PostModels_ByType(string Type_token, string DateType = "Date")
//{
// var res = new List<CustomerSidePostModel>();
// PDBC db = new PDBC();
// db.Connect();
// DataTable dt1 = db.Select("SELECT [G_Id] FROM [tbl_BLOG_Groups] where [GpToken] LIKE N'" + Type_token + "'");
// if (dt1.Rows.Count != 0)
// {
// DataTable dt = db.Select("SELECT [Id],[Title],[Text_min],[Text],(SELECT [ad_firstname]+ ' '+ [ad_lastname] as name FROM [tbl_ADMIN_main]where id_Admin=[WrittenBy_AdminId])as adminName ,[Date],[IsImportant],[Is_Deleted],[Is_Disabled],(SELECT [name]FROM [tbl_BLOG_Categories] where Id=[Cat_Id]) as Category,(SELECT [name]FROM [tbl_BLOG_Groups] where G_Id=[GroupId]) as GroupName,(SELECT top 1 B.PicAddress FROM [tbl_BLOG_Pic_Connector] as A inner join [tbl_ADMIN_UploadStructure_ImageAddress] as B on A.[PicId]=B.PicID where A.PostId=Id)as Pic,(SELECT [ad_avatarprofile] FROM[tbl_ADMIN_main] where id_Admin=WrittenBy_AdminId) as AdminPic ,(SELECT[B_TypeToken] FROM [tbl_BLOG_PostType] WHERE B_TypeId=[TypeId]) as TypeId FROM [tbl_BLOG_Post] WHERE [GroupId] = " + dt1.Rows[0]["B_TypeId"]);
// db.DC();
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// var model = new CustomerSidePostModel()
// {
// Id = Convert.ToInt32(dt.Rows[i]["Id"]),
// by = dt.Rows[i]["adminName"].ToString(),
// Category = dt.Rows[i]["Category"].ToString(),
// InGroup = dt.Rows[i]["GroupName"].ToString(),
// GPIDforPostPAge = dt.Rows[i]["GroupId"].ToString(),
// ImagePath = dt.Rows[i]["Pic"].ToString(),
// IsDeleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
// IsDisabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
// text = dt.Rows[i]["Text"].ToString(),
// title = dt.Rows[i]["Title"].ToString(),
// text_min = dt.Rows[i]["Text_min"].ToString(),
// date = DateConvert.DateReturner(dt.Rows[i]["Date"].ToString(), DateType),
// AdminPic = dt.Rows[i]["AdminPic"].ToString(),
// PostType = dt.Rows[i]["TypeId"].ToString()
// };
// res.Add(model);
// }
// }
// db.DC();
// return res;
//}
public List <CustomerSidePostModel> PostModels_Chosen(string Cat, int TopSelect, string DateType = "Date")
{
var res = new List <CustomerSidePostModel>();
PDBC db = new PDBC();
string Query = "";
if (Cat == "Popular")
{
Query = "SELECT top " + TopSelect + " [Id],[Title],[Text_min],[Text],(SELECT [ad_firstname]+ ' '+ [ad_lastname] as name FROM [tbl_ADMIN_main]where id_Admin=[WrittenBy_AdminId])as adminName ,[Date],[IsImportant],[Is_Deleted],[Is_Disabled],(SELECT [name]FROM [tbl_BLOG_Categories] where Id=[Cat_Id]) as Category,(SELECT [name]FROM [tbl_BLOG_Groups] where G_Id=[GroupId]) as GroupName,(SELECT top 1 B.PicAddress FROM [tbl_BLOG_Pic_Connector] as A inner join [tbl_ADMIN_UploadStructure_ImageAddress] as B on A.[PicId]=B.PicID where A.PostId=Id)as Pic,(SELECT [ad_avatarprofile] FROM[tbl_ADMIN_main] where id_Admin=WrittenBy_AdminId) as AdminPic ,(SELECT[B_TypeToken] FROM [tbl_BLOG_PostType] WHERE B_TypeId=[TypeId]) as TypeId FROM [tbl_BLOG_Post] Order By(SELECT COUNT(*) FROM [tbl_BLOG_Comment] WHERE PostId=Id) DESC,Date DESC";
}
else if (Cat == "New")
{
Query = "SELECT top " + TopSelect + " [Id],[Title],[Text_min],[Text],(SELECT [ad_firstname]+ ' '+ [ad_lastname] as name FROM [tbl_ADMIN_main]where id_Admin=[WrittenBy_AdminId])as adminName ,[Date],[IsImportant],[Is_Deleted],[Is_Disabled],(SELECT [name]FROM [tbl_BLOG_Categories] where Id=[Cat_Id]) as Category,(SELECT [name]FROM [tbl_BLOG_Groups] where G_Id=[GroupId]) as GroupName,(SELECT top 1 B.PicAddress FROM [tbl_BLOG_Pic_Connector] as A inner join [tbl_ADMIN_UploadStructure_ImageAddress] as B on A.[PicId]=B.PicID where A.PostId=Id)as Pic,(SELECT [ad_avatarprofile] FROM[tbl_ADMIN_main] where id_Admin=WrittenBy_AdminId) as AdminPic ,(SELECT[B_TypeToken] FROM [tbl_BLOG_PostType] WHERE B_TypeId=[TypeId]) as TypeId FROM [tbl_BLOG_Post] Order By(Date)DESC";
}
db.Connect();
DataTable dt = db.Select(Query);
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new CustomerSidePostModel()
{
Id = Convert.ToInt32(dt.Rows[i]["Id"]),
by = dt.Rows[i]["adminName"].ToString(),
Category = dt.Rows[i]["Category"].ToString(),
InGroup = dt.Rows[i]["GroupName"].ToString(),
GPIDforPostPAge = dt.Rows[i]["GroupId"].ToString(),
ImagePath = dt.Rows[i]["Pic"].ToString(),
IsDeleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
IsDisabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
text = dt.Rows[i]["Text"].ToString(),
title = dt.Rows[i]["Title"].ToString(),
text_min = dt.Rows[i]["Text_min"].ToString(),
date = DateConvert.DateReturner(dt.Rows[i]["Date"].ToString(), DateType),
AdminPic = dt.Rows[i]["AdminPic"].ToString(),
PostType = dt.Rows[i]["TypeId"].ToString()
};
res.Add(model);
}
return(res);
}
public List <CustomerSidePostModel> UserPostModels(string Cat, int Page, int Id, string search, string DateType = "Date")
{
var res = new List <CustomerSidePostModel>();
PDBC db = new PDBC();
db.Connect();
DataTable dt = db.Select(QueryMaker_BlogPost(Cat, Page, Id, search));
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new CustomerSidePostModel()
{
Id = Convert.ToInt32(dt.Rows[i]["Id"]),
by = dt.Rows[i]["adminName"].ToString(),
Category = dt.Rows[i]["Category"].ToString(),
InGroup = dt.Rows[i]["GroupName"].ToString(),
GPIDforPostPAge = dt.Rows[i]["GroupId"].ToString(),
ImagePath = dt.Rows[i]["Pic"].ToString(),
IsDeleted = Convert.ToInt32(dt.Rows[i]["Is_Deleted"]),
IsDisabled = Convert.ToInt32(dt.Rows[i]["Is_Disabled"]),
text = dt.Rows[i]["Text"].ToString(),
title = dt.Rows[i]["Title"].ToString(),
text_min = dt.Rows[i]["Text_min"].ToString(),
date = DateConvert.DateReturner(dt.Rows[i]["Date"].ToString(), DateType),
AdminPic = dt.Rows[i]["AdminPic"].ToString()
};
if (string.IsNullOrEmpty(model.ImagePath))
{
model.ImagePath = NoImage;
}
res.Add(model);
}
return(res);
}
