public SubjectCreationResult EditSubjectThesisById(Subject_Thesis subject) { var check = db.Subject_Thesis.Where(x => x.id == subject.id).FirstOrDefault(); if (check == null) { return(new SubjectCreationResult { IsSuccess = false }); } else { var sub = db.Subject_Thesis.Where(x => (x.id != subject.id) && (x.subthesis_id == subject.subthesis_id || x.name == subject.name)).FirstOrDefault(); if (sub != null) { return(new SubjectCreationResult { IsSuccess = false }); } else { check.subthesis_id = subject.subthesis_id; check.name = subject.name; db.SaveChanges(); return(new SubjectCreationResult { IsSuccess = true, Subthesis_Id = check.subthesis_id, Name = check.name }); } } //var sub = db.Subject_Thesis.Where(x => x.id == subject.id).FirstOrDefault(); //if (sub == null) //{ // return new SubjectCreationResult // { // IsSuccess = false // }; //} //else //{ // sub.subthesis_id = subject.subthesis_id; // sub.name = subject.name; // db.SaveChanges(); // return new SubjectCreationResult // { // IsSuccess = true, // Subthesis_Id = sub.subthesis_id, // Name = sub.name // }; //} }
public string DeleteSubjectThesis(Subject_Thesis subject) { var thesis = db.Theses.Where(x => x.sub_id == subject.id).ToList(); foreach (var item in thesis) { db.Theses.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_Thesis.Where(x => x.id == subject.id).FirstOrDefault(); db.Subject_Thesis.Remove(sub); db.SaveChanges(); return("Xóa thành công"); }