public bool DeleteLoaiTB(LoaiTB ttloaiTB) { SqlConnection con = new SqlConnection(strQuery); con.Open(); SqlCommand cmd = new SqlCommand("delete from LoaiThietBi where MaLoaiTB=@idLoaiTB", con); cmd.Parameters.AddWithValue("@idLoaiTB", ttloaiTB.maLoaiTB); cmd.ExecuteNonQuery(); con.Close(); return(true); }
public void UpdateLoaiTB(LoaiTB ttloaiTB) { SqlConnection con = new SqlConnection(strQuery); con.Open(); SqlCommand cmd = new SqlCommand("update LoaiThietBi set TenLoaiTB=@tenLoaiTB, XuatXu=@xuatXu where MaLoaiTB=@idLoaiTB", con); cmd.Parameters.AddWithValue("@idLoaiTB", ttloaiTB.maLoaiTB); cmd.Parameters.AddWithValue("@tenLoaiTB", ttloaiTB.tenLoaiTB); cmd.Parameters.AddWithValue("@xuatXu", ttloaiTB.xuatXu); cmd.ExecuteNonQuery(); con.Close(); }
public string InsertLoaiTB(LoaiTB ttLoaiTB) { string Message; SqlConnection con = new SqlConnection(strQuery); con.Open(); SqlCommand cmd = new SqlCommand("insert into LoaiThietBi(TenLoaiTB,XuatXu) values(@tenLoaiTB,@xuatXu)", con); cmd.Parameters.AddWithValue("@tenLoaiTB", ttLoaiTB.tenLoaiTB); cmd.Parameters.AddWithValue("@xuatXu", ttLoaiTB.xuatXu); int result = cmd.ExecuteNonQuery(); if (result == 1) { Message = ttLoaiTB.tenLoaiTB + "them thanh cong"; } else { Message = ttLoaiTB.tenLoaiTB + "them khong thanh cong"; } con.Close(); return(Message); }