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