//增加一条评论
public void Add(Comment comment)
{
using (var db = new compusDB())
{
var com = db.Comment.Where(p => p.id == comment.id).FirstOrDefault();
if (com == null)
{
//防止在News再添加一个对象
var ne = db.News.Where(p => p.id == comment.newsid.id).FirstOrDefault();
comment.newsid = ne;
comment.newsid.commentNum++;//对应的新鲜事的评论数加一
com = comment;
db.Comment.Add(com);
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
Console.WriteLine(com.text);
}
else
{
Console.WriteLine("该数据已存在");
}
}
}
//根据学号删除
public void Delect(long id)
{
using (var context = new compusDB())
{
var us = context.User.Where(p => p.id == id).FirstOrDefault();
if (us != null)
{
context.User.Remove(us);
context.SaveChanges();
}
}
}
//删除一条记录
public void deleteCourseScore(short userId, long courseId)
{
using (var context = new compusDB())
{
var score = context.CourseScore.FirstOrDefault(p => p.userid == userId && p.courseid == courseId);
if (score != null)
{
context.CourseScore.Remove(score);
context.SaveChanges();
}
}
}
//根据id删除数据
public void deleteId(long id)
{
using (var context = new compusDB())
{
var ne = context.News.Where(p => p.id == id).FirstOrDefault();
if (ne != null)
{
context.News.Remove(ne);
context.SaveChanges();
}
else
{
Console.WriteLine("记录不存在");
}
}
}
//根据评论内容删除记录
public void delectText(string text)
{
using (var context = new compusDB())
{
var comment = context.Comment.Where(p => p.text == text).FirstOrDefault();
if (comment != null)
{
context.Comment.Remove(comment);
context.SaveChanges();
}
else
{
Console.WriteLine("记录不存在");
}
}
}
//根据用户id删除该用户写的全部评论
public void delectUserId(int useid)
{
using (var context = new compusDB())
{
var comment = context.Comment.Where(p => p.userid == userid).FirstOrDefault();
if (comment != null)
{
context.Comment.Remove(comment);
context.SaveChanges();
}
else
{
Console.WriteLine("记录不存在");
}
}
}
//增加点赞数
public void addRates(long id)
{
using (var context = new compusDB())
{
var ne = context.News.Where(p => p.id == id).FirstOrDefault();
if (ne != null)
{
ne.rates++;
Console.WriteLine(ne.rates);
context.SaveChanges();
}
else
{
Console.WriteLine("不存在记录");
}
}
}
//根据id修改，内容
public void Modify(long id, string text)
{
using (var context = new compusDB())
{
var ne = context.News.Where(p => p.id == id).FirstOrDefault();
if (ne != null)
{
ne.text = text;
Console.WriteLine(ne.text);
context.SaveChanges();
}
else
{
Console.WriteLine("不存在记录");
}
}
}
//根据课程名删除一条记录
public void Delete(string coName)
{
using (var context = new compusDB())
{
var score = context.Course.FirstOrDefault(p => p.courseName == coName);
if (score != null)
{
context.Course.Remove(score);
context.SaveChanges();
Console.WriteLine("删除成功");
}
else
{
Console.WriteLine("不存在该记录");
}
}
}
//增加一条新鲜事
public void Add(News co)
{
using (var db = new compusDB())
{
var ne = db.News.Where(p => p.id == co.id).FirstOrDefault();
if (ne == null)
{
ne = co;
db.News.Add(ne);
db.SaveChanges();
Console.WriteLine(ne.text);
}
else
{
Console.WriteLine("该数据已存在");
}
}
}
//根据评论，修改评论内容
public void modifyText(string oldtext, string text)
{
using (var context = new compusDB())
{
var comm = context.Comment.Where(p => p.text == oldtext).FirstOrDefault();
if (comm != null)
{
comm.text = text;
comm.createdTime = System.DateTime.Now.ToString();
Console.WriteLine("已修改");
context.SaveChanges();
}
else
{
Console.WriteLine("记录不存在");
}
}
}
//增加
public void addCourseScore(CourseScore co)
{
using (var db = new compusDB())
{
var courselist = db.CourseScore.Where(p => p.courseid == co.courseid).ToList();
var course = courselist.Where(p => p.userid == co.userid).FirstOrDefault();
if (course == null)
{
db.CourseScore.Add(co);
db.SaveChanges();
Console.WriteLine(teacherName);
}
else
{
Console.WriteLine("该数据已存在");
}
}
}
//根据userid删除数据
public void deleteUserId(long id)
{
using (var context = new compusDB())
{
var ne = context.News.Where(p => p.userid == id).ToList();
if (ne != null)
{
foreach (News s in ne)
{
context.News.Remove(s);
context.SaveChanges();
Console.WriteLine("已删除");
}
}
else
{
Console.WriteLine("记录不存在");
}
}
}
//删除所有数据
public void DeleteAll()
{
using (var context = new compusDB())
{
var comm = context.Comment.ToList();
if (comm != null)
{
foreach (Comment co in comm)
{
context.Comment.Remove(co);
Console.WriteLine("已删除");
}
context.SaveChanges();
}
else
{
Console.WriteLine("记录不存在");
}
}
}
public void Add(User us)
{
using (var context = new compusDB())
{
var use = context.User.Where(p => p.id == us.id).FirstOrDefault();
if (use == null)
{
use = us;
context.User.Add(us);
try { context.SaveChanges(); }
catch (Exception e)
{
Console.WriteLine(e);
Console.ReadLine();
}
}
else
{
Console.WriteLine("数据已存在");
}
}
}
public void modifiedCouseScore(short score, double gradePoint, long courseid, long userid, string courseType, short credits, string teacherName, string school, int yea, bool term)
{
using (var context = new compusDB())
{
var cs = context.CourseScore.FirstOrDefault(p => p.userid == userid && p.courseid == courseid);
if (cs != null)
{
cs.score = score;
cs.gradePoint = gradePoint;
cs.courseType = courseType;
cs.credits = credits;
cs.teacherName = teacherName;
cs.school = school;
cs.Year = yea;
cs.Term = term;
context.SaveChanges();
}
else
{
Console.WriteLine("不存在该记录");
}
}
}