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