public string uploadPost(Post_Table post_table)
{
string query_status = "failed";
using (MlaDatabaseEntities context = new MlaDatabaseEntities())
{
try
{
context.Post_Table.Add(post_table);
if (context.SaveChanges() > 0)
{
query_status = "ok";
return(query_status);
}
else
{
return(query_status);
}
}
catch (Exception e)
{
query_status = "failed" + e.ToString();
return(query_status);
}
}
}
public ActionResult Details(int id, Article article, Rate rate)
{
using (DbAccessEntity db = new DbAccessEntity())
{
Post_Table post = db.Post_Table.Where(x => x.postid == id).FirstOrDefault();
if (post.comments != null)
{
article.comments = JsonConvert.DeserializeObject <List <Comment> >(post.comments);
}
Rate.rateList.Clear();
if (post.rating != null)
{
Rate.rateList = JsonConvert.DeserializeObject <List <Rate> >(post.rating);
rate.rating = Rate.getUserRating(Rate.rateList, Session["userid"].ToString());
if (rate.rating != 0)
{
rate.userId = Session["userid"].ToString();
}
}
ViewData["Article"] = post;
ViewData["Comments"] = article;
ViewData["Rate"] = rate;
ViewData["AverageRating"] = Rate.calculateAverageRating(Rate.rateList);
return(View("../Post/ResultView"));
}
}
public ActionResult Create(Post_Table post, Article article, Comment comment)
{
try
{
using (PostEntity pe = new PostEntity())
{
DomainTech.DomainTechService dt = new DomainTech.DomainTechService();
List <Domain_Table> DomainList = dt.GetDomainList();
ViewBag.DomainList = new SelectList(DomainList, "did", "domain");
pe.Configuration.ProxyCreationEnabled = false;
List <Technology_Table> TechnologyList = dt.GetTechforDomain(post.domain);
ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology");
//Get the Domain ID
int did = Convert.ToInt32(article.Post.domain);
//Get the Technology ID
int tid = Convert.ToInt32(article.Post.technology);
DomainTechEntity dte = new DomainTechEntity();
//Convert the Domain ID to Domain Name
var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault();
post.domain = d.domain;
//Convert the Technology ID to Technology Name
var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault();
post.technology = t.technology;
//Check for same title
int count = pe.Post_Table.Where(x => x.title == article.Post.title && x.category == true).Count();
if (count > 0)
{
ViewBag.ErrorMessage = "Please modify the TITLE, Article found with same TITLE";
return(View(article));
}
else
{
post.title = article.Post.title;
post.tags = article.Post.tags;
post.content_ = article.Post.content_;
post.date = DateTime.Now;
post.category = true;
post.userid = Session["userid"].ToString();
ViewData["Article"] = post;
pe.Post_Table.Add(post);
pe.SaveChanges();
return(View("ResultView"));
}
}
}
catch
{
return(View());
}
}
/// <summary>
/// 添加职位
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_PostTableData(Post_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@Post_Name", obj.Post_Name)
}));
}
public ActionResult Details(int id)
{
using (PostEntity pe = new PostEntity())
{
Post_Table post = pe.Post_Table.Where(x => x.postid == id).FirstOrDefault();
ViewData["Article"] = post;
return(View("../Post/ResultView"));
}
}
public ActionResult EditPost(int id)
{
using (DbAccessEntity db = new DbAccessEntity())
{
List <Domain_Table> DomainList = db.Domain_Table.ToList();
ViewBag.DomainList = new SelectList(DomainList, "did", "domain");
List <Technology_Table> TechnologyList = db.Technology_Table.ToList();
ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology");
Post_Table post = db.Post_Table.Where(x => x.postid == id).FirstOrDefault();
return(View(post));
}
}
public ActionResult EditPost(int id, Post_Table post)
{
StreamWriter stream = null;
try
{
using (DbAccessEntity db = new DbAccessEntity())
{
List <Domain_Table> DomainList = db.Domain_Table.ToList();
ViewBag.DomainList = new SelectList(DomainList, "did", "domain");
db.Configuration.ProxyCreationEnabled = false;
List <Technology_Table> TechnologyList = db.Technology_Table.ToList();
ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology");
//Get all the values of article/blog
var postvalues = db.Post_Table.Where(x => x.postid == id).FirstOrDefault();
//set all the values
post.postid = postvalues.postid;
post.date = postvalues.date;
post.category = postvalues.category;
post.userid = postvalues.userid;
int did = Convert.ToInt32(post.domain);
int tid = Convert.ToInt32(post.technology);
var d = db.Domain_Table.Where(x => x.did == did).FirstOrDefault();
post.domain = d.domain;
var t = db.Technology_Table.Where(x => x.tid == tid).FirstOrDefault();
post.technology = t.technology;
post.userid = Session["userid"].ToString();
ViewData["Article"] = post;
db.Post_Table.AddOrUpdate(post);
db.SaveChanges();
}
return(View("../Post/ResultView"));
}
catch (Exception e)
{
stream = new StreamWriter(@"D:/EditException.txt");
stream.WriteLine(e);
stream.Close();
return(View());
}
}
public ActionResult DeletePost(int id, FormCollection form)
{
try
{
using (PostEntity pe = new PostEntity())
{
Post_Table post = pe.Post_Table.Where(x => x.postid == id).FirstOrDefault();
pe.Post_Table.Remove(post);
pe.SaveChanges();
}
return(RedirectToAction("ManageUser"));
}
catch
{
return(View());
}
}
/// <summary>
/// 获取全部的职位
/// </summary>
/// <returns></returns>
public List <Post_Table> GetPostTableAll()
{
List <Post_Table> list = new List <Post_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
Post_Table obj = new Post_Table()
{
Post_id = Convert.ToInt32(dr["Post_id"]),
Post_Name = dr["Post_Name"].ToString()
};
list.Add(obj);
}
dr.Close();
return(list);
}
public ActionResult EditPost(int id, Post_Table post)
{
StreamWriter stream = null;
DomainTech.DomainTechService dt = new DomainTech.DomainTechService();
List <DomainTech.Domain_Table> DomainList = dt.GetDomainList();
ViewBag.DomainList = new SelectList(DomainList, "did", "domain");
try
{
using (PostEntity pe = new PostEntity())
{
//Get all the values of article/blog
var postvalues = pe.Post_Table.Where(x => x.postid == id).FirstOrDefault();
//set all the values
post.postid = postvalues.postid;
post.date = postvalues.date;
post.category = postvalues.category;
post.userid = postvalues.userid;
int did = Convert.ToInt32(post.domain);
int tid = Convert.ToInt32(post.technology);
DomainTechEntity dte = new DomainTechEntity();
var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault();
post.domain = d.domain;
var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault();
post.technology = t.technology;
post.userid = Session["userid"].ToString();
ViewData["Article"] = post;
pe.Post_Table.AddOrUpdate(post);
pe.SaveChanges();
}
return(View("../Post/ResultView"));
}
catch (Exception e)
{
stream = new StreamWriter(@"D:/EditException.txt");
stream.WriteLine(e);
stream.Close();
return(View());
}
}
/// <summary>
/// 根据ID查询职位信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public Post_Table GetPostTableByConn(string con)
{
Post_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from Post_Table where Post_id=@Post_id",
CommandType.Text, new SqlParameter[] {
new SqlParameter("@Post_id", con)
});
if (dr.Read())
{
obj = new Post_Table()
{
Post_id = Convert.ToInt32(dr["Post_id"]),
Post_Name = dr["Post_Name"].ToString()
};
}
dr.Close();
return(obj);
}
public ActionResult BrowseBlog(Post_Table post)
{
using (PostEntity pe = new PostEntity())
{
DomainTech.DomainTechService dt = new DomainTech.DomainTechService();
List <Domain_Table> DomainList = dt.GetDomainList();
ViewBag.DomainList = new SelectList(DomainList, "did", "domain");
pe.Configuration.ProxyCreationEnabled = false;
List <Technology_Table> TechnologyList = dt.GetTechforDomain(post.domain);
ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology");
int did = Convert.ToInt32(post.domain);
int tid = Convert.ToInt32(post.technology);
DomainTechEntity dte = new DomainTechEntity();
var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault();
post.domain = d.domain;
var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault();
post.technology = t.technology;
List <Post_Table> browseblog = pe.Post_Table.Where(x => x.domain == post.domain && x.technology == post.technology && x.category == false).ToList();
if (browseblog.Count > 0)
{
ViewData["browseblog"] = browseblog;
}
else
{
ViewData["browseblog"] = null;
ViewBag.Message = "No blog found";
}
}
return(View());
}
public ActionResult BrowseArticle(Post_Table post)
{
using (DbAccessEntity db = new DbAccessEntity())
{
List <Domain_Table> DomainList = db.Domain_Table.ToList();
ViewBag.DomainList = new SelectList(DomainList, "did", "domain");
db.Configuration.ProxyCreationEnabled = false;
List <Technology_Table> TechnologyList = db.Technology_Table.ToList();
ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology");
int did = Convert.ToInt32(post.domain);
int tid = Convert.ToInt32(post.technology);
var d = db.Domain_Table.Where(x => x.did == did).FirstOrDefault();
post.domain = d.domain;
var t = db.Technology_Table.Where(x => x.tid == tid).FirstOrDefault();
post.technology = t.technology;
List <Post_Table> browsearticle = db.Post_Table.Where(x => x.domain == post.domain && x.technology == post.technology && x.category == true).ToList();
if (browsearticle.Count > 0)
{
ViewData["browsearticle"] = browsearticle;
}
else
{
ViewData["browsearticle"] = null;
ViewBag.Message = "No article found";
}
}
return(View());
}
/// <summary>
/// 更改订单信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_PostTableData(Post_Table obj)
{
return(relevanceClass.Update_PostTableData(obj));
}
/// <summary>
/// 添加订单信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_PostTableData(Post_Table obj)
{
return(relevanceClass.Insert_PostTableData(obj));
}
public ActionResult GenerateUserReport(string answer, string inp, Subscriber_Table si, Post_Table ai, TestUser u)
{
if (answer != null)
{
DbAccessEntity te = new DbAccessEntity();
var testsub = (from p in te.Subscriber_Table
join t in te.Test_Table
on p.userid equals t.UserId
where p.userid == inp
select new
{
ID = p.userid,
Domain = t.DomainID,
Score = t.Score,
Technology = t.TechnologyID,
TesTID = t.TestId,
}).ToList();
int i = 0;
foreach (var p in testsub)
{
u.Name = p.ID;
u.Domain[i] = p.Domain;
u.UserId[i] = p.ID;
u.Score[i] = p.Score;
u.TestId[i] = p.TesTID;
if (u.Score[i] <= (0.4) * 10)
{
u.fail = u.fail + 1;
}
else
{
u.pass = u.pass + 1;
}
i++;
}
u.counttest = i;
var artsubq = (from p in te.Subscriber_Table
join e in te.Post_Table
on p.userid equals e.userid
where p.userid == inp
select new
{
ID = p.userid,
Name = p.name,
Title = e.title,
Rating = e.rating,
Technology = e.technology
}).ToList();
i = 0;
double sum = 0;
foreach (var p in artsubq)
{
u.Title[i] = p.Title;
u.Technologylist[i] = p.Technology;
i++;
}
u.countarticle = i;
if (u.countarticle > 0)
{
u.averagerating = (sum / u.countarticle);
}
else
{
u.averagerating = 0;
}
return(View(u));
}
return(View());
}
public ActionResult Create(Post_Table post, Blog blog, Comment comment)
{
StreamWriter stream = null;
try
{
using (PostEntity pe = new PostEntity())
{
DomainTech.DomainTechService dt = new DomainTech.DomainTechService();
List <Domain_Table> DomainList = dt.GetDomainList();
ViewBag.DomainList = new SelectList(DomainList, "did", "domain");
pe.Configuration.ProxyCreationEnabled = false;
List <Technology_Table> TechnologyList = dt.GetTechforDomain(post.domain);
ViewBag.TechnologyList = new SelectList(TechnologyList, "tid", "technology");
//Get the Domain ID
int did = Convert.ToInt32(blog.Post.domain);
//Get the Technology ID
int tid = Convert.ToInt32(blog.Post.technology);
DomainTechEntity dte = new DomainTechEntity();
//Convert the Domain ID to Domain Name
var d = dte.Domain_Table.Where(x => x.did == did).FirstOrDefault();
post.domain = d.domain;
//Convert the Technology ID to Technology Name
var t = dte.Technology_Table.Where(x => x.tid == tid).FirstOrDefault();
post.technology = t.technology;
//Check for same title
int count = pe.Post_Table.Where(x => x.title == blog.Post.title && x.category == false).Count();
if (count > 0)
{
ViewBag.ErrorMessage = "Please modify the TITLE, Blog found with same TITLE";
return(View(blog));
}
else
{
// Add the date, category and
post.title = blog.Post.title;
post.tags = blog.Post.tags;
post.content_ = blog.Post.content_;
post.date = DateTime.Now;
post.category = false;
post.userid = Session["userid"].ToString();
ViewData["Blog"] = post;
pe.Post_Table.Add(post);
pe.SaveChanges();
return(View("../Post/ResultView"));
}
}
}
catch (DbEntityValidationException dbEx)
{
stream = new StreamWriter(@"D:\BlogException.txt");
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
stream.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
stream.Close();
return(View());
}
}
public ActionResult PostComment(Post_Table postTable, Comment comment, Article article, Rate rate, string postId, string commentId, string commentContent)
{
try
{
using (DbAccessEntity pe = new DbAccessEntity())
{
var postIdInt = Convert.ToInt32(postId);
var post = pe.Post_Table.Where(x => x.postid == postIdInt).FirstOrDefault();
if (post.comments != null)
{
article.comments = JsonConvert.DeserializeObject <List <Comment> >(post.comments);
}
if (post.rating != null)
{
Rate.rateList.Clear();
Rate.rateList = JsonConvert.DeserializeObject <List <Rate> >(post.rating);
rate.rating = Rate.getUserRating(Rate.rateList, Session["userid"].ToString());
rate.userId = Session["userid"].ToString();
}
ViewData["Rate"] = rate;
ViewData["AverageRating"] = Rate.calculateAverageRating(Rate.rateList);
ViewData["Article"] = post;
ViewData["Comments"] = article;
comment.userid = Session["userid"].ToString();
comment.date = DateTime.Now;
if (commentContent == null)
{
if (comment.content_ != null)
{
if (article.comments.Count() < 10)
{
comment.postid = "0" + (article.comments.Count() + 1);
}
else
{
comment.postid = (article.comments.Count() + 1).ToString();
}
article.comments.Add(comment);
}
else
{
ViewData["EmptyComment"] = "Put something atleast!";
return(View("ResultView"));
}
}
else if (commentContent != null)
{
var foundParentComment = false;
while (!foundParentComment)
{
foundParentComment = AddCommentToParentComment(article.comments, commentId, commentContent);
}
}
var jsonCommentList = JsonConvert.SerializeObject(article.comments);
post.comments = jsonCommentList;
pe.Post_Table.AddOrUpdate(post);
pe.SaveChanges();
return(View("ResultView"));
}
}
//TODO: Print exception in log
catch (Exception e)
{
return(Content(e.ToString()));
}
}
