public Expose178.Com.Model.User GetUserByEmailID(string strEmailID)
{
Expose178.Com.Model.User user = new Model.User();
DataSet dsUser = null;
Hashtable hshParam = new Hashtable();
Gadget.Addparamater(ref hshParam, "UserID", strEmailID);
dsUser = dbOperator.ProcessData("usp_GetUserByUserIDEmail", hshParam, strDSN);
if (Gadget.DatatSetIsNotNullOrEmpty(dsUser))
{
user.UserID = Gadget.GetDataRowStringValue(dsUser.Tables[0].Rows[0], "UserID");;
user.UserName = Gadget.GetDataRowStringValue(dsUser.Tables[0].Rows[0], "UserName");
user.UserEmail = strEmailID;
user.PwdHash = Gadget.GetDataRowStringValue(dsUser.Tables[0].Rows[0], "PwdHash");
user.PwdSalt = Gadget.GetDataRowStringValue(dsUser.Tables[0].Rows[0], "PwdSalt");
user.IsEffective = Gadget.GetDataRowBoolValue(dsUser.Tables[0].Rows[0], "IsEffective");
user.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dsUser.Tables[0].Rows[0], "LastUpdatedDate");
}
return(user);
}
public IList <Expose178.Com.Model.AritcleType> GetListArticleType()
{
IList <Expose178.Com.Model.AritcleType> listAritcleType = null;
DataSet dsArticleType = GetDataSetArticleType("");
if (Gadget.DatatSetIsNotNullOrEmpty(dsArticleType))
{
listAritcleType = new List <Expose178.Com.Model.AritcleType>();
foreach (DataRow dr in dsArticleType.Tables[0].Rows)
{
Expose178.Com.Model.AritcleType mAritcleType = new Model.AritcleType();
mAritcleType.AritcleTypeCode = Gadget.GetDataRowStringValue(dr, "AritcleTypeCode");
mAritcleType.AritcleTypeDesc = Gadget.GetDataRowStringValue(dr, "AritcleTypeDesc");
mAritcleType.UpdatedByUserID = Gadget.GetDataRowStringValue(dr, "UpdatedByUserID");
mAritcleType.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dr, "LastUpdatedDate");
listAritcleType.Add(mAritcleType);
}
}
return(listAritcleType);
}
public IList <Expose178.Com.Model.ReadRoleType> GetListReadRole()
{
DataSet dsReadRole = GetDataSetReadRole("");
IList <Expose178.Com.Model.ReadRoleType> listReadRole = null;
if (Gadget.DatatSetIsNotNullOrEmpty(dsReadRole))
{
listReadRole = new List <Expose178.Com.Model.ReadRoleType>();
foreach (DataRow dr in dsReadRole.Tables[0].Rows)
{
Expose178.Com.Model.ReadRoleType read = new Model.ReadRoleType();
read.ReadRoleTypeCode = Gadget.GetDataRowStringValue(dr, "ReadRoleTypeCode");
read.ReadRoleTypeDesc = Gadget.GetDataRowStringValue(dr, "ReadRoleTypeDesc");
read.UpdatedByUserID = Gadget.GetDataRowStringValue(dr, "UpdatedByUserID");
read.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dr, "LastUpdatedDate");
listReadRole.Add(read);
}
}
return(listReadRole);
}
public IList <Expose178.Com.Model.ArticleTitle> GetArticleTitle()
{
IList <Expose178.Com.Model.ArticleTitle> listArticleTile = null;
DataSet dsArtileTitle = GetDataSetArticleTitle();
if (Gadget.DatatSetIsNotNullOrEmpty(dsArtileTitle))
{
listArticleTile = new List <Expose178.Com.Model.ArticleTitle>();
foreach (DataRow dr in dsArtileTitle.Tables[0].Rows)
{
Expose178.Com.Model.ArticleTitle art = new Model.ArticleTitle();
art.ArticleID = Gadget.GetDataRowStringValue(dr, "ArticleID");
art.ArticleDate = Gadget.GetDataRowDateTimeValue(dr, "ArticleDate");
art.ArticleTile = Gadget.GetDataRowStringValue(dr, "ArticleTile");
art.ArticleSummary = Gadget.GetDataRowStringValue(dr, "ArticleSummary");
art.ReadNum = Gadget.GetDataRowIntValue(dr, "ReadNum");
art.ReplyNum = Gadget.GetDataRowIntValue(dr, "ReplyNum");
listArticleTile.Add(art);
}
}
return(listArticleTile);
}
public IList <Expose178.Com.Model.ReplyToArticle> GetListReplyToArticle(string strArticleID)
{
IList <Expose178.Com.Model.ReplyToArticle> listReplyToArticle = null;
DataSet dsReplyToArticle = null;
Hashtable hshParam = new Hashtable();
dsReplyToArticle = dbOperator.ProcessData("usp_GetReplyToArticle", hshParam, strDSN);
if (Gadget.DatatSetIsNotNullOrEmpty(dsReplyToArticle))
{
listReplyToArticle = new List <Model.ReplyToArticle>();
foreach (DataRow dr in dsReplyToArticle.Tables[0].Rows)
{
Expose178.Com.Model.ReplyToArticle reply = new Model.ReplyToArticle();
reply.ArticleID = strArticleID;
reply.IsValidated = Gadget.GetDataRowBoolValue(dr, "IsValidated");
reply.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dr, "LastUpdatedDate");
reply.ReplyBody = Gadget.GetDataRowStringValue(dr, "ReplyBody");
reply.ReplyID = Gadget.GetDataRowStringValue(dr, "ReplyID");
reply.UpdatedByUserID = Gadget.GetDataRowStringValue(dr, "UpdatedByUserID");
}
}
return(listReplyToArticle);
}
