public bool Update_TrongTai(TrongTai tt)
 {
     SqlParameter[] pa = new SqlParameter[3];
     pa[0] = new SqlParameter("@matt", tt.Matt);
     pa[1] = new SqlParameter("@tentt", tt.Tentt);
     pa[2] = new SqlParameter("@ngaysinh", tt.Ngaysinh);
     return SQLProvider.Execute_NonQuery("Update_trongtai", pa);
 }
        public bool Insert_TrongTai(TrongTai tt)
        {
            SqlParameter[] pa = new SqlParameter[3];
            string ma = "TT";
            int madb = 0;
            if (string.Compare(tt.Matt, "") != 0)
            {
                madb = int.Parse(tt.Matt.Replace("TT", ""));
            }
            madb++;
            if (madb < 10)
            {
                tt.Matt = ma + "0" + madb;
            }
            else
            {
                tt.Matt = ma + madb;
            }

            pa[0] = new SqlParameter("@matt", tt.Matt);
            pa[1] = new SqlParameter("@tentt", tt.Tentt);
            pa[2] = new SqlParameter("@ngaysinh", tt.Ngaysinh);
            return SQLProvider.Execute_NonQuery("insert_trongtai", pa);
        }
 public bool Update_TrongTai(TrongTai tt)
 {
     TrongTaiAdapter a = TrongTaiAdapter.CreateTrongTaiAdapter();
     return a.Update_TrongTai(tt);
 }
 //Tab Trong tai
 public bool Insert_TrongTai(TrongTai tt)
 {
     TrongTaiAdapter a = TrongTaiAdapter.CreateTrongTaiAdapter();
     return a.Insert_TrongTai(tt);
 }
 public bool Delete_TrongTai(TrongTai tt)
 {
     SqlParameter[] pa = new SqlParameter[1];
     pa[0] = new SqlParameter("@matt", tt.Matt);
     return SQLProvider.Execute_NonQuery("Delete_trongtai", pa);
 }