public Expose178.Com.Model.ArticleAddtional GetArticleAddtional(string strArticleID) { Expose178.Com.Model.ArticleAddtional addtion = new Model.ArticleAddtional(); try { DataSet dsArticleAdd = GetArticleAddtionalByArticleID(strArticleID); if (Gadget.DatatSetIsNotNullOrEmpty(dsArticleAdd)) { addtion.AdditionalID = Gadget.GetDataRowStringValue(dsArticleAdd.Tables[0].Rows[0], "AdditionalID"); addtion.ArticleID = strArticleID; addtion.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dsArticleAdd.Tables[0].Rows[0], "LastUpdatedDate"); addtion.ReadNum = Gadget.GetDataRowIntValue(dsArticleAdd.Tables[0].Rows[0], "ReadNum"); addtion.ReplyNum = Gadget.GetDataRowIntValue(dsArticleAdd.Tables[0].Rows[0], "ReplyNum"); addtion.UpdatedByUserID = Gadget.GetDataRowStringValue(dsArticleAdd.Tables[0].Rows[0], "UpdatedByUserID"); } } catch (Exception ex) { Hashtable hshParam = new Hashtable(); hshParam.Add("Error", ex.Message); hshParam.Add("UID", Expose178.Com.GadgetScripts.Gadget.GetUserID()); Expose178.Com.UtilityFactory.Log.WriteLog(hshParam, "ProxyArticle.GetArticleAddtional", UtilityFactory.LogType.LogToDB); } return(addtion); }
public Expose178.Com.Model.Article GetArticle(string strArticleID) { Expose178.Com.Model.Article art = new Model.Article(); DataSet dsArticle = GetArticleByID(strArticleID); if (Gadget.DatatSetIsNotNullOrEmpty(dsArticle)) { art.ArticleID = strArticleID; art.ArticleTile = Gadget.GetDataRowStringValue(dsArticle.Tables[0].Rows[0], "ArticleTile"); art.ArticleDate = Gadget.GetDataRowDateTimeValue(dsArticle.Tables[0].Rows[0], "ArticleDate"); art.ArticleBody = Gadget.GetDataRowStringValue(dsArticle.Tables[0].Rows[0], "ArticleBody"); art.BackgroundImgUrl = Gadget.GetDataRowStringValue(dsArticle.Tables[0].Rows[0], "BackgroundImgUrl"); art.IsDraft = Gadget.GetDataRowBoolValue(dsArticle.Tables[0].Rows[0], "IsDraft"); art.IsValidated = Gadget.GetDataRowBoolValue(dsArticle.Tables[0].Rows[0], "IsValidated"); art.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dsArticle.Tables[0].Rows[0], "LastUpdatedDate"); string strUID = Gadget.GetDataRowStringValue(dsArticle.Tables[0].Rows[0], "UpdatedByUserID"); string strstrAritcleTypeCode = Gadget.GetDataRowStringValue(dsArticle.Tables[0].Rows[0], "AritcleTypeCode"); string strReadRoleTypeCode = Gadget.GetDataRowStringValue(dsArticle.Tables[0].Rows[0], "ReadRoleTypeCode"); ArticleReply reply = new ArticleReply(); User user = new User(); art.ListReply = reply.GetListReplyToArticle(strArticleID); art.ReadRoleType = GetReadRoleType(strReadRoleTypeCode); art.User = user.GetUserByUID(strUID); art.AritcleType = GetAritcleType(strstrAritcleTypeCode); } return(art); }
public Expose178.Com.Model.AritcleType GetArticleType(string strArticleTypeCode) { DataSet dsArticleType = GetDataSetArticleType(strArticleTypeCode); Expose178.Com.Model.AritcleType mAritcleType = null; if (Gadget.DatatSetIsNotNullOrEmpty(dsArticleType)) { mAritcleType = new Model.AritcleType(); mAritcleType.AritcleTypeCode = Gadget.GetDataRowStringValue(dsArticleType.Tables[0].Rows[0], "AritcleTypeCode"); mAritcleType.AritcleTypeDesc = Gadget.GetDataRowStringValue(dsArticleType.Tables[0].Rows[0], "AritcleTypeDesc"); mAritcleType.UpdatedByUserID = Gadget.GetDataRowStringValue(dsArticleType.Tables[0].Rows[0], "UpdatedByUserID"); mAritcleType.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dsArticleType.Tables[0].Rows[0], "LastUpdatedDate"); } return(mAritcleType); }
public Expose178.Com.Model.ReadRoleType GetReadRole(string strReadRoleTypeCode) { DataSet dsReadRole = GetDataSetReadRole(""); Expose178.Com.Model.ReadRoleType read = null; if (Gadget.DatatSetIsNotNullOrEmpty(dsReadRole)) { read = new Model.ReadRoleType(); read.ReadRoleTypeCode = Gadget.GetDataRowStringValue(dsReadRole.Tables[0].Rows[0], "ReadRoleTypeCode"); read.ReadRoleTypeDesc = Gadget.GetDataRowStringValue(dsReadRole.Tables[0].Rows[0], "ReadRoleTypeDesc"); read.UpdatedByUserID = Gadget.GetDataRowStringValue(dsReadRole.Tables[0].Rows[0], "UpdatedByUserID"); read.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dsReadRole.Tables[0].Rows[0], "LastUpdatedDate"); } return(read); }
private Expose178.Com.Model.ReadRoleType GetReadRoleType(string strReadRoleTypeCode) { Expose178.Com.Model.ReadRoleType ReadRoleType = new Model.ReadRoleType(); DataSet dsReadRoleType = null; Hashtable hshParam = new Hashtable(); dsReadRoleType = dbOperator.ProcessData("usp_GetReadRoleType", hshParam, strDSN); if (Gadget.DatatSetIsNotNullOrEmpty(dsReadRoleType)) { ReadRoleType.ReadRoleTypeCode = strReadRoleTypeCode; ReadRoleType.ReadRoleTypeDesc = Gadget.GetDataRowStringValue(dsReadRoleType.Tables[0].Rows[0], "ReadRoleTypeDesc"); ReadRoleType.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dsReadRoleType.Tables[0].Rows[0], "LastUpdatedDate"); ReadRoleType.UpdatedByUserID = Gadget.GetDataRowStringValue(dsReadRoleType.Tables[0].Rows[0], "UpdatedByUserID"); } return(ReadRoleType); }
private Expose178.Com.Model.AritcleType GetAritcleType(string strAritcleTypeCode) { Expose178.Com.Model.AritcleType arType = new Model.AritcleType(); DataSet dsAritcleType = null; Hashtable hshParam = new Hashtable(); Gadget.Addparamater(ref hshParam, "AritcleTypeCode", strAritcleTypeCode); dsAritcleType = dbOperator.ProcessData("usp_GetAritcleType", hshParam, strDSN); if (Gadget.DatatSetIsNotNullOrEmpty(dsAritcleType)) { arType.AritcleTypeCode = strAritcleTypeCode; arType.AritcleTypeDesc = Gadget.GetDataRowStringValue(dsAritcleType.Tables[0].Rows[0], "AritcleTypeDesc"); arType.LastUpdatedDate = Gadget.GetDataRowDateTimeValue(dsAritcleType.Tables[0].Rows[0], "LastUpdatedDate"); arType.UpdatedByUserID = Gadget.GetDataRowStringValue(dsAritcleType.Tables[0].Rows[0], "UpdatedByUserID"); } return(arType); }
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); }