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"; } } }