public static List <CenterAdmin> GetCenterAdminList() { List <CenterAdmin> list = new List <CenterAdmin>(); SqlConnection conn = new SqlConnection(GetConnectionString()); conn.Open(); String query = "SELECT * FROM " + DBDefine.DATABASE_TABLE_ACCOUNT + " WHERE " + DBDefine.DATABASE_COLUMN_ACCOUNT_ROLE + " = 2"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { int id = int.Parse(dr[DBDefine.DATABASE_COLUMN_ACCOUNT_ID].ToString().Trim()); String name = dr[DBDefine.DATABASE_COLUMN_ACCOUNT_NAME].ToString().Trim(); int role = int.Parse(dr[DBDefine.DATABASE_COLUMN_ACCOUNT_ROLE].ToString().Trim()); String email = dr[DBDefine.DATABASE_COLUMN_ACCOUNT_EMAIL].ToString().Trim(); String password = dr[DBDefine.DATABASE_COLUMN_ACCOUNT_PASSWORD].ToString().Trim(); int centerId = int.Parse(dr[DBDefine.DATABASE_COLUMN_ACCOUNT_CENTERID].ToString().Trim()); CenterAdmin acc = new CenterAdmin(id, name, role, email, password, centerId); list.Add(acc); } conn.Close(); return(list); }
private static async Task SeedCenterAdmin(ApplicationDbContext context, UserManager <ApplicationUser> userManager) { CenterAdmin centerAdmin = new CenterAdmin(); var createdCenterAdmin = await userManager.FindByEmailAsync("*****@*****.**"); centerAdmin.Id = createdCenterAdmin.Id; context.CenterAdmins.Add(centerAdmin); context.SaveChanges(); CenterAdmin centerAdmin2 = new CenterAdmin(); var createdCenterAdmin2 = await userManager.FindByEmailAsync("*****@*****.**"); centerAdmin2.Id = createdCenterAdmin2.Id; context.CenterAdmins.Add(centerAdmin2); context.SaveChanges(); }
private bool addAdminCenter(AdminClientViewModel newCenter, int centerID) { ApplicationUser admin = new ApplicationUser() { Name = newCenter.AdminName, UserName = newCenter.Username, PasswordHash = newCenter.Password, PhoneNumber = newCenter.Phone, Email = newCenter.Email }; ApplicationDbContext DBContext = new ApplicationDbContext(); ApplicationStore store = new ApplicationStore(DBContext); ApplicationManager manager = new ApplicationManager(store); IdentityResult Result = manager.CreateAsync(admin, newCenter.Password).Result; var RoleResult = manager.AddToRoleAsync(admin.Id, "CenterAdmin").Result; if (Result.Succeeded) { IAuthenticationManager authentication = HttpContext.GetOwinContext().Authentication; SignInManager <ApplicationUser, string> signIn = new SignInManager <ApplicationUser, string>(manager, authentication); signIn.SignIn(admin, false, false); // add admin info to center admin table CenterAdmin centerAdmin = new CenterAdmin() { UserID = admin.Id, NID = newCenter.NID, CenterID = centerID, NiDImage = newCenter.NID, }; context.CenterAdmins.Add(centerAdmin); context.SaveChanges(); return(true); } else { string error = ""; foreach (var err in Result.Errors) { error += err + " "; } ModelState.AddModelError("", error); return(false); } }