public ActionResult Create([Bind(Include = "BorrowHistoryId,BookId,UserId,BorrowDate,ReturnDate")] BorrowHistory borrowHistory)
{
if (ModelState.IsValid)
{
string name = User.Identity.Name;
BooksDb2 db2 = new BooksDb2();
var xx = from i in db2.Users
where i.Name == name
select i.UserId;
int userid = xx.ToList().FirstOrDefault();
BorrowHistory bh = new BorrowHistory();
bh.UserId = userid;
bh.BookId = borrowHistory.BookId;
bh.BorrowDate = borrowHistory.BorrowDate;
bh.ReturnDate = borrowHistory.ReturnDate;
db.BorrowHistories.Add(bh);
db.SaveChanges();
// db.BorrowHistories.Add(borrowHistory);
// db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BookId = new SelectList(db.Mybooks, "BookId", "BookId", borrowHistory.BookId);
ViewBag.UserId = new SelectList(db.Users, "UserId", "UserId", borrowHistory.UserId);
return(View(borrowHistory));
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
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);
// 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>");
BooksDb2 db = new BooksDb2();
User u = new User();
u.Name = user.Email;
db.Users.Add(u);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
// GET: BorrowHistories/Create
public ActionResult Create(int?id)
{
string name = User.Identity.Name;//asp-net user table
BooksDb2 db2 = new BooksDb2();
var xx = from i in db2.Users
where i.Name == name
select i.UserId;
int userid = xx.ToList().FirstOrDefault();
ViewBag.userid1 = userid;
Debug.WriteLine("userid is " + userid);
ViewBag.BookId = new SelectList(db.Mybooks.Where(n => n.BookId == id), "BookId", "BookId");
ViewBag.UserId = new SelectList(db.Users, "UserId", "UserId");
//ViewBag.BookId = new SelectList(db.Mybooks.Where(n => n.BookId == id), "BookId", "BookId");
(from p in db2.Mybooks
where p.BookId == id
select p).ToList().ForEach(x => x.qty = x.qty - 1);
db2.SaveChanges();
return(View());
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
//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);
// // 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>");
// BooksDb2 db = new BooksDb2();
// User u = new User();
// u.Name = model.Email;
// //db.Users.
// db.Users.Add(u);//Database user table
// //db.Users.Name = db.Users.Email;
// db.SaveChanges();
// //var userid = (from p in db.Users
// // where p.Name == User.Identity.Name
// // select p.UserId).ToString();
// //System.Diagnostics.Debug.WriteLine(userid);
// ApplicationDbContext context = new ApplicationDbContext();
// var userStore = new UserStore<ApplicationUser>(context);
// UserManager.AddToRole(user.Id,"User");
// return RedirectToAction("Index2", "Books");
// }
// AddErrors(result);
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);
// 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>");
ApplicationDbContext context = new ApplicationDbContext();
var userStore = new UserStore <ApplicationUser>(context);
var UserManager = new UserManager <ApplicationUser>(userStore);
User c = new User();
c.Name = model.Email;
BooksDb2 m1 = new BooksDb2();
m1.Users.Add(c);
m1.SaveChanges();
UserManager.AddToRole(user.Id, "User");
return(RedirectToAction("Login", "Account"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
// GET: Books
public ActionResult Index2(string bkname, string authname, string sortOrder, int?id)
{
//Session["userid"] = db.Users.Where(n=>n.UserId);
ViewBag.Auth = isAdminUser();
//Session["Userid"]= Convert.ToInt32(from p in db.Users
// where p.Name == User.Identity.Name
// select p.UserId);
// var bh = db.Users.Where(x => x.Name == User.Identity.Name).Select(x=> x.UserId).ToString();
//int bh2 = int.Parse(bh);
//Session["Userid"] = bh2;
//System.Diagnostics.Debug.WriteLine(Session["Userid"]);
BooksDb2 Db2 = new BooksDb2();
//(from p in Db2.Mybooks
// where p.BookId == id
// select p).ToList().ForEach(x => x.qty = x.qty + 1);
//var userId = User.Identity.GetUserId();
//Session["Userid"] = userId;
//System.Diagnostics.Debug.WriteLine(Session["Userid"]);
//BorrowHistory borrowHistory = db.BorrowHistories.Find(id);
//db.BorrowHistories.Remove(borrowHistory);
//db.SaveChanges();
//return RedirectToAction("Index");
Db2.SaveChanges();
if (!ViewBag.Auth)//For user
{
var books = from b in db.Mybooks
where b.qty > 0
select b;
if (!string.IsNullOrEmpty(bkname))
{
books = books.Where(x => x.Title.Contains(bkname));
}
if (!string.IsNullOrEmpty(authname))
{
books = books.Where(x => x.Author.Contains(authname));
}
ViewBag.TitleSortParam = sortOrder == "Title" ? "Title_desc" : "Title";
ViewBag.AuthorParam = sortOrder == "Author" ? "Author_desc" : "Author";
switch (sortOrder)
{
case "Title_desc":
books = books.OrderByDescending(x => x.Title);
break;
case "Title":
books = books.OrderBy(x => x.Title);
break;
case "Author":
books = books.OrderBy(x => x.Author);
break;
case "Author_desc":
books = books.OrderByDescending(x => x.Author);
break;
}
return(View(books));
}
else//For admin
{
var books = from b in db.Mybooks
select b;
if (!string.IsNullOrEmpty(bkname))
{
books = books.Where(x => x.Title.Contains(bkname));
}
if (!string.IsNullOrEmpty(authname))
{
books = books.Where(x => x.Author.Contains(authname));
}
ViewBag.TitleSortParam = sortOrder == "Title" ? "Title_desc" : "Title";
ViewBag.AuthorParam = sortOrder == "Author" ? "Author_desc" : "Author";
switch (sortOrder)
{
case "Title_desc":
books = books.OrderByDescending(x => x.Title);
break;
case "Title":
books = books.OrderBy(x => x.Title);
break;
case "Author":
books = books.OrderBy(x => x.Author);
break;
case "Author_desc":
books = books.OrderByDescending(x => x.Author);
break;
}
return(View(books));
}
}
