public bool Addcomment(string desc, int news_id)
{
ESHOP_NEWS_COMMENT cm = new ESHOP_NEWS_COMMENT();
cm.NEWS_ID = news_id;
cm.COMMENT_CONTENT = desc;
cm.COMMENT_PUBLISHDATE = DateTime.Now;
db.ESHOP_NEWS_COMMENTs.InsertOnSubmit(cm);
db.SubmitChanges();
return true;
}
//Insert comment
public bool Insert_comment(int _Newsid, string name, string email, string content)
{
ESHOP_NEWS_COMMENT cm = new ESHOP_NEWS_COMMENT();
cm.NEWS_ID = _Newsid;
cm.COMMENT_CHECK = 0;
cm.COMMENT_STATUS = 0;
cm.COMMENT_NAME = name;
cm.COMMENT_EMAIL = email;
cm.COMMENT_CONTENT = content;
cm.COMMENT_PUBLISHDATE = DateTime.Now;
db.ESHOP_NEWS_COMMENTs.InsertOnSubmit(cm);
db.SubmitChanges();
return true;
}
public bool AddQuestion(string name, string email, string title, string desc, int news_id, int _rating)
{
ESHOP_NEWS_COMMENT cm = new ESHOP_NEWS_COMMENT();
cm.NEWS_ID = news_id;
cm.COMMENT_CONTENT = desc;
cm.COMMENT_NAME = name;
cm.COMMENT_EMAIL = email;
cm.COMMENT_FIELD1 = title;
cm.COMMENT_PUBLISHDATE = DateTime.Now;
cm.COMMENT_RATING = _rating;
cm.COMMENT_STATUS = 1;
db.ESHOP_NEWS_COMMENTs.InsertOnSubmit(cm);
db.SubmitChanges();
return true;
}
private void detach_ESHOP_NEWS_COMMENTs(ESHOP_NEWS_COMMENT entity)
{
this.SendPropertyChanging();
entity.ESHOP_NEW = null;
}
partial void DeleteESHOP_NEWS_COMMENT(ESHOP_NEWS_COMMENT instance);
partial void UpdateESHOP_NEWS_COMMENT(ESHOP_NEWS_COMMENT instance);
partial void InsertESHOP_NEWS_COMMENT(ESHOP_NEWS_COMMENT instance);
public bool Inser_comment_News(string _sCat_Seo_Url, string _sNews_seo_url, string name, string email, string content)
{
int _Newsid = Getid(_sCat_Seo_Url, _sNews_seo_url);
ESHOP_NEWS_COMMENT cm = new ESHOP_NEWS_COMMENT();
cm.NEWS_ID = _Newsid;
cm.COMMENT_CHECK = 0;
cm.COMMENT_STATUS = 0;
cm.COMMENT_NAME = name;
cm.COMMENT_EMAIL = email;
cm.COMMENT_CONTENT = content;
cm.COMMENT_PUBLISHDATE = DateTime.Now;
db.ESHOP_NEWS_COMMENTs.InsertOnSubmit(cm);
db.SubmitChanges();
return true;
}
