public User Check()
{
// ket noi database
SqlConnection connect = QueryData.Connect_Server();
// mo Database va viet cau truy van , co dau cach nen co dong ngoac [User Name]
String query = "Select * from Account where UseName = '" + textBox1.Text.Trim() + "' and passwordID = '" + textBox2.Text.Trim() + "'";
DataTable dt = QueryData.Queryresult(connect, query); // tra ra du lieu cua cau truy van
User userlog = null;
if (dt.Rows.Count == 1) // neu chi co 1 mau du lieu khop
{
userlog = new User(Int32.Parse(dt.Rows[0][0].ToString()), dt.Rows[0][1].ToString().Trim(), dt.Rows[0][2].ToString().Trim(), dt.Rows[0][3].ToString().Trim(), dt.Rows[0][4].ToString().Trim());
return(userlog);// lay hang [0][0] cua Rows la UserName
}
else
{
MessageBox.Show("Username or password incorrect"); // thong bao khi dang nhap ko thanh coong
return(userlog);
}
}
public void borrowBook(Book a) // thoi gian muon trong 2 tuan
{
DateTime date = DateTime.Now;
if (setBook.Count <= 2) // moi lan muon toi da 3 cuon sach
{
SqlConnection connect = QueryData.Connect_Server();
String query = "INSERT INTO Bookitem (IDBook,IDUser,Title,Borrowed,Duedate,Bkstatus) VALUES('" + a.IDBook.ToString().Trim() + "','" + idUser.ToString().Trim() + "',N'" + a.Titletext.Trim() + "',CONVERT(datetime, '" + date.ToShortDateString().ToString() + "', 103) , CONVERT(datetime, '" + date.AddDays(14).ToShortDateString().ToString() + "',103),'" + "Being borrowed" + "')";
bool kq = QueryData.ExecuteNonQueryBook(connect, query); // thuc thi luu du lieu
if (kq)
{
setBook.Add(new Bookitem {
IDBook = a.IDBook, IDUser = idUser, Titletext = a.Titletext, Borrowtime = date, DueTime = date.AddDays(14), Statusbool = "Booked"
});
MessageBox.Show("Borrowed successfully !!!!");
}
}
else
{
MessageBox.Show("Only borrow max three book");
}
}
private void button1_Click(object sender, EventArgs e) // them du lieu dang ky vao Database
{
label2.Text = null;
label3.Text = null;
label4.Text = null;
if (textBox1.Text == "Username" || textBox1.Text == "")
{
label2.Text = "Please, enter username!";
}
if (textBox2.Text == "Password" || textBox2.Text == "")
{
label3.Text = "Please, enter pasword!";
}
if (textBox3.Text == "Email" || textBox3.Text == "")
{
label4.Text = "Please, enter email!";
}
else if (!isEmail())
{
label4.Text = "Email is invalid";
}
if (label2.Text == "" && label3.Text == "" && label4.Text == "")
{
SqlConnection connect = QueryData.Connect_Server();
String permiss = "User";
String query = "INSERT INTO Account (UseName,PasswordID,Email,Permission) VALUES('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "' ,'" + permiss + "')";
bool kq = QueryData.ExecuteNonQueryUser(connect, query); // luu tai khoan nguoi dung
if (kq)
{
MessageBox.Show("Resgister successfully !!!!");
label2.Text = null;
label3.Text = null;
label4.Text = null;
}
}
}
