public bool Add(ClassAdmin.Admin admin) { string query = "INSERT INTO TTAdmin VALUES ( @AccAdmin , @TenAD , @GioiTinh , @NgaySinh , @SDT , @Email , @DiaChi )"; object[] para = new object[] { admin.AccAdmin, admin.TenAD, admin.GioiTinh, admin.NgaySinh, admin.SDT, admin.Email, admin.DiaChi }; if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0) { return(true); } return(false); }
public bool Edit(ClassAdmin.Admin admin) { string AccAdmin = admin.AccAdmin; string query = "UPDATE TTAdmin SET TenAD = @TenAD , GioiTinh = @GioiTinh , NgaySinh = @NgaySinh , SDT = @SDT , Email = @eEmail , DiaChi = @DiaChi WHERE AccAdmin = @AccAdmin "; object[] para = new object[] { admin.TenAD, admin.GioiTinh, admin.NgaySinh, admin.SDT, admin.Email, admin.DiaChi, admin.AccAdmin }; if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0) { return(true); } return(false); }