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");
}
