public IQueryable <Models.Category> GetCategories() { var _db = new TuSach.Models.BookContext(); IQueryable <Models.Category> query = _db.Categories; return(query); }
public bool CheckDangNhap(string name, string matkhau) { var dt = new Models.BookContext(); IQueryable <Models.User> query = dt.Users; int tontai = query.Where(u => u.UserName == name && u.Password == matkhau).Count(); return(tontai == 0 ? false : true); }
public bool CheckUser(string name, string password) { var _db = new Models.BookContext(); IQueryable <Models.User> query = _db.Users; int tontai = query.Where(u => u.UserName == name && u.Password == password).Count(); return(tontai == 0 ? false : true); }
public bool isExisBook(int id) { var _db = new Models.BookContext(); IQueryable <Models.Book> query = _db.Books; int tontai = query.Where(u => u.BookID == id).Count(); if (tontai != 0) { return(true); } else { return(false); } }
public bool CheckUser(string name) { var _db = new Models.BookContext(); IQueryable <Models.User> query = _db.Users; int tontai = query.Where(u => u.UserName == name).Count(); if (tontai == 0) { return(true); } else { return(false); } }
public void Submit_DangKi(object sender, EventArgs e) { string name = Request.Form.Get("taikhoan"); string matkhau = Request.Form.Get("matkhau"); string testmatkhau = Request.Form.Get("testmatkhau"); if (matkhau == testmatkhau) { if (CheckUser(name)) { var _db = new Models.BookContext(); var newUser = new Models.User { UserName = name, Password = matkhau }; _db.Users.Add(newUser); _db.SaveChanges(); Response.Cookies.Add(new HttpCookie("taikhoan", name)); Response.Cookies.Add(new HttpCookie("matkhau", matkhau)); Response.Redirect("Default.aspx"); } else { message = "tai khoan da ton tai"; } } else { message = "mat khau khong giong nhau"; } }
public void Submit_Book(object sender, EventArgs e) { string name = Request.Form.Get("BookName"); int cateId = Int32.Parse(Request.Form.Get("CategoryId")); string description = Request.Form.Get("Description"); string imagePath = Request.Form.Get("ImagePath"); string content = Request.Form.Get("Content"); var _db = new Models.BookContext(); var newBook = new Models.Book { BookName = name, Description = description, ImagePath = imagePath, Content = content, CategoryID = cateId }; _db.Books.Add(newBook); _db.SaveChanges(); }