public IDataResult <List <ContextDetail> > GetContextDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from contexts in context.Contexts
join publisher in context.Publishers
on contexts.PublisherId equals publisher.PublisherId
join question in context.Questions
on contexts.QuestionId equals question.QuestionId
join remak in context.Remaks
on contexts.RemakId equals remak.RemakId
join audio in context.Audios
on contexts.ContextAudio equals audio.AudioId
join video in context.Videos
on contexts.ContextVideo equals video.VideoId
join picture in context.Pictures
on contexts.ContextPicture equals picture.PictureId
join book in context.Books
on contexts.BookId equals book.BookId
select new ContextDetail
{
BookName = book.BookName,
ContextText = contexts.ContextText,
BookTitle = book.CategoryId,
PublisherName = publisher.PublisherName,
QuestionAnswer = question.QuestionAnswer,
QuestionAudio = question.QuestionAudio,
QuestionPicture = question.QuestionPicture,
QuestionText = question.QuestionText,
QuestionVideo = question.QuestionVideo,
Remak = remak.RemakId
};
return(new SuccessDataResult <List <ContextDetail> >(result.ToList()));
}
}
public IDataResult <List <AnswerDetail> > GetAnswerDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from answer in context.Answers
join question in context.Questions
on answer.AnswerId equals question.QuestionAnswer
join remak in context.Remaks
on answer.Remak equals remak.RemakId
join teacher in context.Teachers
on answer.Owner equals teacher.TeacherId
select new AnswerDetail
{
OwnerName = teacher.FirstName + " " + teacher.LastName,
QuestionText = question.QuestionText,
QuestionAudio = question.QuestionAudio,
QuestionVideo = question.QuestionVideo,
AnswerText = answer.AnswerText,
AnswerAudio = answer.AnswerAudio,
AnswerPicture = answer.AnswerPicture,
AnswerVideo = answer.AnswerVideo,
QuestionPicture = question.QuestionPicture,
RemakId = remak.RemakId
};
return(new SuccessDataResult <List <AnswerDetail> >(result.ToList()));
}
}
public IDataResult <List <AudioDetail> > GetAudioDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from audio in context.Audios
join question in context.Questions
on audio.AudioId equals question.QuestionId
join answer in context.Answers
on audio.AudioId equals answer.AnswerAudio
join teacher in context.Teachers
on audio.TeacherId equals teacher.TeacherId
join student in context.Students
on audio.StudentId equals student.StudentId
join remak in context.Remaks
on audio.RemakId equals remak.RemakId
select new AudioDetail
{
AudioName = audio.AudioName,
TeacherName = teacher.FirstName + " " + teacher.LastName,
StudentName = student.FirstName + " " + student.LastName,
RemakText = remak.Text
};
return(new SuccessDataResult <List <AudioDetail> >(result.ToList()));
}
}
public IDataResult <List <QuestionDetail> > GetAllQuestionDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from question in context.Questions
join book in context.Books
on question.BookId equals book.BookId
join answer in context.Answers
on question.QuestionAnswer equals answer.AnswerId
join video in context.Videos
on question.QuestionVideo equals video.VideoId
join audio in context.Audios
on question.QuestionAudio equals audio.AudioId
join picture in context.Pictures
on question.QuestionPicture equals picture.PictureId
select new QuestionDetail
{
BookName = book.BookName,
QuestionText = question.QuestionText,
QuestionPicture = question.QuestionPicture,
QuestionAudio = question.QuestionAudio,
QuestionVideo = question.QuestionVideo,
QuestionAnswer = question.QuestionAnswer
};
return(new SuccessDataResult <List <QuestionDetail> >(result.ToList()));
}
}
public IDataResult <List <Book> > GetAllByBookCategory()
{
using (EBookContext context = new EBookContext())
{
var result = from book in context.Books
join category in context.Categories
on book.CategoryId equals category.CategoryId
select book.BookId == category.CategoryId;
return(new SuccessDataResult <List <Book> >(result.ToList()));
}
}
public IDataResult <List <CategoryDetail> > GetCategoryDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from category in context.Categories
select new CategoryDetail
{
CategoryName = category.CategoryName
};
return(new SuccessDataResult <List <CategoryDetail> >(result.ToList()));
}
}
public IDataResult <List <CityDetail> > GetCityDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from city in context.Cities
select new CityDetail
{
CityName = city.CityName
};
return(new SuccessDataResult <List <CityDetail> >(result.ToList()));
}
}
public IDataResult <List <AdminDetail> > GetAdminDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from admin in context.Admins
select new AdminDetail
{
Name = admin.FirstName + " " + admin.LastName,
Mail = admin.Mail,
RegisterDate = admin.RegisterDate
};
return(new SuccessDataResult <List <AdminDetail> >(result.ToList()));
}
}
public IDataResult <List <CosulantDetail> > GetCosullantDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from cosulant in context.Cosulants
join student in context.Students
on cosulant.StudentId equals student.StudentId
join category in context.Categories
on cosulant.CategoryId equals category.CategoryId
select new CosulantDetail
{
ConsulantName = cosulant.FirstName,
ConsulantLastName = cosulant.LastName,
StudentName = student.FirstName,
ConsulantSpeciality = category.CategoryName
};
return(new SuccessDataResult <List <CosulantDetail> >(result.ToList()));
}
}
public async Task <ActionResult> Register(RegisterViewModel model, string FirstName, string LastName, int Age, bool IsMale)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
EBookContext db = new EBookContext();
Profile profile = new Profile()
{
Login = model.Email,
FirstName = FirstName,
LastName = LastName,
Age = Age,
IsMale = IsMale
};
db.Profiles.Add(profile);
db.SaveChanges();
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
return(RedirectToAction("Index", "Home"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public IDataResult <List <BookDetail> > GetBookDetail()
{
using (EBookContext context = new EBookContext())
{
var result = from book in context.Books
join category in context.Categories
on book.CategoryId equals category.CategoryId
join publisher in context.Publishers
on book.PublisherId equals publisher.PublisherId
select new BookDetail
{
BookId = book.BookId,
BookName = book.BookName,
CategoryName = category.CategoryName,
Publisher = publisher.PublisherName,
DateOfIssue = book.DateOfIssue,
Description = book.Description
};
return(new SuccessDataResult <List <BookDetail> >(result.ToList()));
}
}
