public bool edit_MA(tinhtrang maTT)
{
SqlConnection conn = new SqlConnection(connectString);
string sql = "update TINHTRANG set TinhTrang= @ten Where MaTT= @ma";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ma", maTT.Matinhtrang);
cmd.Parameters.AddWithValue("@ten", maTT.Tentinhtrang);
conn.Open();
int count = cmd.ExecuteNonQuery();
conn.Close();
return(count >= 1);
}
public bool add_Tinhtrang(tinhtrang tt)
{
SqlConnection conn = new SqlConnection(connectString);
string sql = "insert into TINHTRANG values (@ma ,@ten)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ma", tt.Matinhtrang);
cmd.Parameters.AddWithValue("@ten", tt.Tentinhtrang);
conn.Open();
int count = cmd.ExecuteNonQuery();
conn.Close();
return(count >= 1);
}
protected void btnsua_Click(object sender, EventArgs e)
{
int matt = int.Parse(txtmaTrang.Text.ToString());
tinhtrang TT = new tinhtrang(matt, txttenTrang.Text);
if (TinhTrangdau.edit_MA(TT))
{
Label4.Text = "EDIT SUCCESS";
grvtinhtrang.DataSource = TinhTrangdau.getTalbe("select * from TINHTRANG ");
Page.DataBind();
}
else
{
Label4.Text = " ERROR EDIT";
}
}
protected void btnthem_Click(object sender, EventArgs e)
{
if (TinhTrangdau.check_Matt(txtmaTrang.Text))
{
Label4.Text = "Trung MA. vui long nhap MA khac";
}
else
{
int matt = int.Parse(txtmaTrang.Text.ToString());
tinhtrang TT = new tinhtrang(matt, txttenTrang.Text);
if (TinhTrangdau.add_Tinhtrang(TT))
{
Label4.Text = "DA ADD";
grvtinhtrang.DataSource = TinhTrangdau.getTalbe("select * from TINHTRANG ");
Page.DataBind();
}
else
{
Label4.Text = "ERROR ADD";
}
}
}
