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); }