public void Sua(string username, string fullname, string email, string address, int role)
{
//câu lệnh update vào sql server
string update = "update acount set fullname=N'" + fullname + "',email=N'" + email + "',address=N'" + address + "',roleid='" + role + "' where username='******'";
db.ExcuteNonquery(update);
}
protected void btnThem_Click(object sender, EventArgs e)
{
if (int.Parse(ddMenuCha.SelectedValue.ToString()) == 0)
{
int cateid1 = MaxMenuID() + 1;
string link = "BaiViet.aspx?mid=" + cateid1;
string sql = "insert into category(cateid,catename,link) values(" + cateid1 + ",N'" + txtTenMenu.Text + "','" + link + "')";
ac.ExcuteNonquery(sql);
WriteSiteMap();
Response.Redirect("quanlymenu.aspx");
}
else
{
int cateid = MaxMenuID() + 1;
string link = "BaiViet.aspx?mid=" + cateid;
string sql = "insert into category values('" + cateid + "',N'" + txtTenMenu.Text + "','" + link + "','" + ddMenuCha.SelectedValue.ToString() + "')";
ac.ExcuteNonquery(sql);
WriteSiteMap();
Response.Redirect("quanlymenu.aspx");
}
}
/// <summary>
/// click vào button Them
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnThem_Click(object sender, EventArgs e)
{
if (dl.kiemtra("Acount", "username", txtTenDangNhap.Text) <= 0)
{
//câu lệnh thêm vào sql server
string caulenh = "insert into Acount values(N'" + txtTenDangNhap.Text + "',N'" + txtMatKhau.Text + "',N'" + ddlQuyen.SelectedValue.ToString() + "',N'" + txtHoTen.Text + "',N'" + txtDiaChiMail.Text + "',N'" + txtDiaChi.Text + "',N'')";
dl.ExcuteNonquery(caulenh);
Response.Write("<script language='javascript'>alert('Thêm tài khoản thành công')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Tài khoản đã tồn tại')</script>");
}
}
