public void SuaK(DTOFaculty K)
{
OpenConnect();
string edit = "update [QLDSV].[QLDSV].[Faculty] set tenkhoa=@NameFaculty where makhoa=@CodeFaculty";
SqlCommand cmd = new SqlCommand(edit, conn);
cmd.Parameters.Add(new SqlParameter("@CodeFaculty", K.MaKhoa));
cmd.Parameters.Add(new SqlParameter("@NameFaculty", K.TenKhoa));
cmd.ExecuteNonQuery();
CloseConnect();
}
public void ThemK(DTOFaculty K)
{
OpenConnect();
string insert = "insert into [QLDSV].[QLDSV].[Faculty] values (@CodeFaculty, @NameFaculty)";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.Parameters.Add(new SqlParameter("@CodeFaculty", K.MaKhoa));
cmd.Parameters.Add(new SqlParameter("@NameFaculty", K.TenKhoa));
cmd.ExecuteNonQuery();
CloseConnect();
}
