public SubjectCreationResult EditSubjectEssayById(Subject_Essay subject) { var check = db.Subject_Essay.Where(x => x.id == subject.id).FirstOrDefault(); if (check == null) { return(new SubjectCreationResult { IsSuccess = false }); } else { var sub = db.Subject_Essay.Where(x => (x.id != subject.id) && (x.subessay_id == subject.subessay_id || x.name == subject.name)).FirstOrDefault(); if (sub != null) { return(new SubjectCreationResult { IsSuccess = false }); } else { check.subessay_id = subject.subessay_id; check.name = subject.name; db.SaveChanges(); return(new SubjectCreationResult { IsSuccess = true, Subessay_Id = check.subessay_id, Name = check.name }); } } //var sub = db.Subject_Essay.Where(x => x.id == subject.id).FirstOrDefault(); //if (sub == null) //{ // return new SubjectCreationResult // { // IsSuccess = false // }; //} //else //{ // sub.subessay_id = subject.subessay_id; // sub.name = subject.name; // db.SaveChanges(); // return new SubjectCreationResult // { // IsSuccess = true, // Subessay_Id = sub.subessay_id, // Name = sub.name // }; //} }
public string DeleteSubjectEssay(Subject_Essay subject) { var essay = db.Essays.Where(x => x.sub_id == subject.id).ToList(); foreach (var item in essay) { db.Essays.Remove(item); db.SaveChanges(); } var rate = db.RateStars.Where(x => x.sub_id == subject.id).ToList(); foreach (var item in rate) { db.RateStars.Remove(item); db.SaveChanges(); } var time = db.Times.Where(x => x.sub_id == subject.id).ToList(); foreach (var item in time) { db.Times.Remove(item); db.SaveChanges(); } var search = db.SearchFiles.Where(x => x.sub_id == subject.id).ToList(); foreach (var item in search) { db.SearchFiles.Remove(item); db.SaveChanges(); } var sub = db.Subject_Essay.Where(x => x.id == subject.id).FirstOrDefault(); db.Subject_Essay.Remove(sub); db.SaveChanges(); return("Xóa thành công"); }