protected void submit_edit_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(hidden_id.Value);
DanhMucDuAn cate = new DanhMucDuAn();
cate.TenDanhMuc = txtTenDanhMuc_edit.Text;
cate.MoTa = txtMoTa_edit.Text;
cate.status = checkStatus_edit.Checked;;
obj.update(cate, id);
//load list
Response.Redirect(Request.Url.ToString());
}
protected void submit_create_Click(object sender, EventArgs e)
{
//kiem tra trong
if (txtMoTa_create.Text == "" || txtTenDanhMuc_create.Text == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "vanh", "blank()", true);
return;
}
//them
DanhMucDuAn cate = new DanhMucDuAn();
cate.TenDanhMuc = txtTenDanhMuc_create.Text;
cate.MoTa = txtMoTa_create.Text;
/*cate.status = true;
* if (!checkStatus_create.Checked) cate.status = false;*/
cate.status = checkStatus_create.Checked;
cate.created_at = DateTime.Now;
obj.create(cate);
//load list
Response.Redirect(Request.Url.ToString());
}
public void loadCategory_DuAn()
{
DanhMucDuAn.DataSource = obj_DuAn.danhmuc_header();
DanhMucDuAn.DataBind();
}
public void update(DanhMucDuAn c, int id)
{
string sql = "update tbl_DanhMucDuAn set TenDanhMuc = N'" + c.TenDanhMuc + "', MoTa = N'" + c.MoTa + "', status = '" + c.status + "' where id = '" + id + "'";
obj.ExecuteNonQuery(sql);
}
public void create(DanhMucDuAn c)
{
string sql = "insert tbl_DanhMucDuAn values(N'" + c.TenDanhMuc + "' , N'" + c.MoTa + "', '" + c.status + "', '" + c.created_at + "' )";
obj.ExecuteNonQuery(sql);
}
