public SubjectCreationResult EditSubjectById(Subject_Ebook subject)
{
var check = db.Subject_Ebook.Where(x => x.id == subject.id).FirstOrDefault();
if (check == null)
{
return(new SubjectCreationResult
{
IsSuccess = false
});
}
else
{
var sub = db.Subject_Ebook.Where(x => (x.id != subject.id) &&
(x.subebook_id == subject.subebook_id || x.name == subject.name)).FirstOrDefault();
if (sub != null)
{
return(new SubjectCreationResult
{
IsSuccess = false
});
}
else
{
check.subebook_id = subject.subebook_id;
check.name = subject.name;
db.SaveChanges();
return(new SubjectCreationResult
{
IsSuccess = true,
Subebook_Id = check.subebook_id,
Name = check.name,
});
}
}
//var sub = db.Subject_Ebook.Where(x => x.id == subject.id).FirstOrDefault();
//if (sub == null)
//{
// return new SubjectCreationResult
// {
// IsSuccess = false
// };
//}
//else
//{
// sub.subebook_id = subject.subebook_id;
// sub.name = subject.name;
// db.SaveChanges();
// return new SubjectCreationResult
// {
// IsSuccess = true,
// Subebook_Id = sub.subebook_id,
// Name = sub.name,
// };
//}
}
public string DeleteFileById(Subject_Ebook subject)
{
var ebook = db.Ebooks.Where(x => x.id == subject.id).ToList();
foreach (var item in ebook)
{
db.Ebooks.Remove(item);
db.SaveChanges();
}
return("Xóa thành công");
}
public string DeleteSubjectById(Subject_Ebook subject)
{
var ebook = db.Ebooks.Where(x => x.sub_id == subject.id).ToList();
foreach (var item in ebook)
{
db.Ebooks.Remove(item);
db.SaveChanges();
}
var sub = db.Subject_Ebook.Where(x => x.id == subject.id).FirstOrDefault();
MyHub.DeleteSubject(subject.id);
db.Subject_Ebook.Remove(sub);
db.SaveChanges();
return("Xóa thành công");
}
public string DeleteSubjectById(Subject_Ebook subject)
{
var ebook = db.Ebooks.Where(x => x.sub_id == subject.id).ToList();
foreach (var item in ebook)
{
db.Ebooks.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_Ebook.Where(x => x.id == subject.id).FirstOrDefault();
db.Subject_Ebook.Remove(sub);
db.SaveChanges();
return("Xóa thành công");
}
