public static void InsertWard()
{
using (NHAMISContext dbcontext = new NHAMISContext())
{
string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Wards.txt");
string[] Wards = File.ReadAllLines(path);
foreach (string WardLine in Wards)
{
string wardName = WardLine.Split('=')[0];
string subcountyName = WardLine.Split('=')[1];
var subcountyId = dbcontext.Subcounties.Where(n => n.SubCountyName == subcountyName).Select(c => c.Id).FirstOrDefault();
Subcounty subcounty = dbcontext.Subcounties.Find(subcountyId);
Ward Ward = new Ward()
{
WardName = wardName, Subcounty = subcounty
};
dbcontext.Wards.Add(Ward);
}
dbcontext.SaveChanges();
}
}
public static void InsertConstituency()
{
using (NHAMISContext dbcontext = new NHAMISContext())
{
string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Constituencies.txt");
string[] Constituencies = File.ReadAllLines(path);
foreach (string ConstituencyLine in Constituencies)
{
string subcountyName = ConstituencyLine.Split('=')[0];
string countyName = ConstituencyLine.Split('=')[1];
var CountyId = dbcontext.Counties.Where(n => n.CountyName == countyName).Select(f => f.Id).FirstOrDefault();
County County = dbcontext.Counties.Find(CountyId);
Subcounty subcounty = new Subcounty()
{
SubCountyName = subcountyName, County = County
};
dbcontext.Subcounties.Add(subcounty);
}
dbcontext.SaveChanges();
}
}
public static IdentityRole GetCurrentUserRole()
{
NHAMISContext db = new NHAMISContext();
var userId = HttpContext.Current.User.Identity.GetUserId();
var userRole = db.UserRoles.Where(i => i.UserId == userId).FirstOrDefault();
var RoleId = userRole.RoleId;
return db.Roles.Where(r => r.Id == RoleId).FirstOrDefault();
}
public static UserDetails GetCurrentUserDetails()
{
NHAMISContext db = new NHAMISContext();
var userId = HttpContext.Current.User.Identity.GetUserId();
var userRole = db.UserRoles.Where(i => i.UserId == userId).FirstOrDefault();
UserDetails userDetails = db.UserDetails.Where(n => n.UserId == userId).FirstOrDefault();
UserDetailsViewModel userDetailsView = new UserDetailsViewModel();
userDetailsView.UserDetails = userDetails;
userDetailsView.RoleId = userRole.RoleId;
return userDetails;
}
public void CreateRole()
{
NHAMISContext context = new NHAMISContext();
var rolemanager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
if (!rolemanager.RoleExists("Admin"))
{
var role = new IdentityRole();
role.Name = "Admin";
rolemanager.Create(role);
}
if (!rolemanager.RoleExists("User"))
{
var role = new IdentityRole();
role.Name = "User";
rolemanager.Create(role);
}
}
public static void InsertCounty()
{
using (NHAMISContext dbcontext = new NHAMISContext())
{
string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Counties.txt");
string[] Counties = File.ReadAllLines(path);
foreach (string CountyLine in Counties)
{
string countyName = CountyLine;
County County = new County()
{
CountyName = countyName
};
dbcontext.Counties.Add(County);
}
dbcontext.SaveChanges();
}
}
public static void InsertPostalCodes()
{
using (NHAMISContext dbcontext = new NHAMISContext())
{
string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/PostalCodesKenya.txt");
string[] postalCodesFile = File.ReadAllLines(path);
foreach (string postalCodeLine in postalCodesFile)
{
string postalNameText = (postalCodeLine.Split('-')[0]).ToUpper();
int postalCodeText = Int32.Parse(postalCodeLine.Split('-')[1]);
PostalCode postalCode = new PostalCode()
{
Code = postalCodeText, Town = postalNameText
};
dbcontext.PostalCodes.Add(postalCode);
}
dbcontext.SaveChanges();
}
}
private void CreateRolesandUsers()
{
ApplicationDbContext context = new ApplicationDbContext();
NHAMISContext db = new NHAMISContext();
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
if (!roleManager.RoleExists("Admin"))
{
var role = new IdentityRole();
role.Name = "Admin";
roleManager.Create(role);
}
var user = new ApplicationUser();
user.UserName = "******";
user.Email = "*****@*****.**";
string userPWD = "Admin@123";
var chkUser = UserManager.Create(user, userPWD);
if (chkUser.Succeeded)
{
var result1 = UserManager.AddToRole(user.Id, "Admin");
NominatingBodyCategory ncat = new NominatingBodyCategory();
ncat.Name = "Ministries";
db.NominatingBodyCategories.Add(ncat);
db.SaveChanges();
NominatingBody nbody = new NominatingBody();
nbody.Name = "ICT Authority";
nbody.Order = 20;
nbody.NominatingBodyCategoryId = ncat.Id;
db.NominatingBodies.Add(nbody);
db.SaveChanges();
if (db.PostalCodes.Count() <= 0)
{
ModelService.InsertPostalCodes();
}
var userDetails = new UserDetails();
userDetails.Designation = "Sofwtare Developer";
userDetails.EmailAddress = "*****@*****.**";
userDetails.MobileNo = "0724924465";
userDetails.NominatingBodyId = nbody.Id;
userDetails.OtherNames = "Shangala Mwadwaa";
userDetails.OtherNo = "0733274699";
userDetails.PFNumber = "0099";
userDetails.PostalAddress = 5457;
userDetails.PostalCodeId = db.PostalCodes.Where(c => c.Code == 100).FirstOrDefault().Id;
userDetails.Surname = "Mwadwaa";
userDetails.Title = "Mr.";
userDetails.UserId = user.Id;
userDetails.UserStatus = true;
db.UserDetails.Add(userDetails);
db.SaveChanges();
}
if (!roleManager.RoleExists("User"))
{
var role = new IdentityRole();
role.Name = "User";
roleManager.Create(role);
}
if (!roleManager.RoleExists("ApproverStageOne"))
{
var role = new IdentityRole();
role.Name = "ApproverStageOne";
roleManager.Create(role);
}
if (!roleManager.RoleExists("ApproverStageTwo"))
{
var role = new IdentityRole();
role.Name = "ApproverStageTwo";
roleManager.Create(role);
}
if (!roleManager.RoleExists("ApproverStageThree"))
{
var role = new IdentityRole();
role.Name = "ApproverStageThree";
roleManager.Create(role);
}
if (!roleManager.RoleExists("Super Admin"))
{
var role = new IdentityRole();
role.Name = "Super Admin";
roleManager.Create(role);
}
}
