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);
}
}
