public IHttpActionResult DeleteSite(int id, int UILoginUserID, string UILoginPassword, int SiteID)
{
if (!Global.CheckUserIDAndPasswordWithSiteID(db, UILoginUserID, UILoginPassword, SiteID, "DeleteSite"))
{
return(BadRequest());
}
Site site = db.Sites.Find(id);
if (site == null)
{
return(NotFound());
}
UserSite userSite = db.UserSites.Find(site.ID);
if (userSite.UserID != UILoginUserID)
{
return(BadRequest());
}
User user = db.Users.Find(UILoginUserID);
if (user == null)
{
return(BadRequest());
}
if (!user.IsSiteAdmin)
{
return(BadRequest());
}
db.Sites.Remove(site);
db.SaveChanges();
return(Ok(site));
}
/// <summary>
/// get the UserSite objects with the given username, sitename and siteurl
/// </summary>
/// <param name="username"></param>
/// <param name="siteName"></param>
/// <param name="siteUrl"></param>
/// <returns>a UserSite object</returns>
public UserSite GetUserSitesByUsernameSitenameSiteurl(string username, string siteName, string siteUrl)
{
string sqlQuery = "SELECT * FROM [dbo].[UserSites] WHERE [Username]=@username AND [Sitename]=@siteName AND [Siteurl]=@siteUrl";
SqlParameter[] param =
{
new SqlParameter("@username", username),
new SqlParameter("@siteName", siteName),
new SqlParameter("@siteUrl", siteUrl),
};
SqlDataReader dr = DBHelper.ExecuteReader(sqlQuery, param);
UserSite userSite = null;
if (dr.Read())
{
userSite = new UserSite
{
username = Convert.ToString(dr["Username"]),
siteName = Convert.ToString(dr["Sitename"]),
siteUrl = Convert.ToString(dr["Siteurl"])
};
if (dr["Icon"] == null)
{
userSite.icon = null;
}
else
{
userSite.icon = Convert.ToString(dr["Icon"]);
}
}
return(userSite);
}
/// <summary>
/// get all the UserSite objects belongs to the given username
/// </summary>
/// <param name="username"></param>
/// <returns>a List<UserSite> containing all the sites of this user</returns>
public IEnumerable <UserSite> GetUserSitesByUsername(string username)
{
string sqlQuery = "SELECT * FROM [dbo].[UserSites] WHERE [Username]=@username";
SqlParameter[] param =
{
new SqlParameter("@username", username),
};
DataTable dt = DBHelper.ExecuteDataTable(sqlQuery, param);
List <UserSite> list = new List <UserSite>();
foreach (DataRow row in dt.Rows)
{
UserSite userSite = new UserSite
{
username = (string)row["Username"],
siteName = (string)row["Sitename"],
siteUrl = (string)row["Siteurl"],
};
if (row["Icon"] == null)
{
userSite.icon = null;
}
else
{
userSite.icon = Convert.ToString(row["Icon"]);
}
list.Add(userSite);
}
return(list);
}
public void AddUpdateUserSite(UserSiteCreateModel model)
{
DeleteSiteForUser(model.UserId);
List <UserSite> urList = new List <UserSite>();
using (var db = new PCVEntities())
{
if (model.SiteId.IsNotBlank())
{
foreach (var item in model.SiteId)
{
UserSite oneRoleMenu = new UserSite();
oneRoleMenu.UserId = model.UserId;
oneRoleMenu.SiteId = item;
oneRoleMenu.CreatedDate = DateTime.Now;
oneRoleMenu.CreatedBy = MySession.Current.UserName;
if (model.IsDefault == item.To <string>())
{
oneRoleMenu.IsDefaultSite = true;
}
else
{
oneRoleMenu.IsDefaultSite = false;
}
urList.Add(oneRoleMenu);
}
db.UserSite.AddRange(urList);
db.SaveChanges();
}
}
}
public void AddDefaultUserSites(UserSite userSite)
{
if (!CheckForEmpty())
{
_context.UserSites.Add(userSite);
}
}
public async Task <IActionResult> Rate(int id, int point)
{
var newsSite = _context.NewsSite.FirstOrDefault(x => x.Id == id);
var userSite = _context.UserSite.FirstOrDefault(x => x.SiteId == id && x.UserId == userManager.GetUserId(User));
if (id != newsSite.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
if (userSite == null)
{
userSite = new UserSite()
{
UserId = userManager.GetUserId(User), SiteId = id, pont = point
};
newsSite.Points += point;
_context.Add(userSite);
}
else if (userSite.pont == 0)
{
userSite.pont = point;
newsSite.Points += point;
_context.Update(userSite);
}
else if (userSite.pont == point)
{
newsSite.Points += point * (-1);
userSite.pont = 0;
_context.Update(userSite);
}
_context.Update(newsSite);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!NewsSiteExists(newsSite.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Browse)));
}
return(View("Browse"));
}
// post Method save data to database
public JsonResult SaveData([Bind(Include = "ID,UserName,Email,Password")] UserSite model)
{
_Context.newUser.Add(model);
_Context.SaveChanges();
// call Method to Creat Email Template with id newUser
BuildEmail(model.ID);
return
(Json("Riegister successfuly", JsonRequestBehavior.AllowGet));
}
public JsonResult RegisterConfirm(int RegID)
{
UserSite USER = _Context.newUser.Where(X => X.ID == RegID).FirstOrDefault();
_Context.SaveChanges();
var msg = "Your Email Is Verified!";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
public void BuildEmail(int iDReg) // id NewUser
{
string body = System.IO.File.ReadAllText(HostingEnvironment.MapPath("~/BuildEmail/") + "Text" + ".cshtml"); //path View
UserSite RegInfo = _Context.newUser.Where(x => x.ID == iDReg).FirstOrDefault(); // get user from DataBase
var url = "http://*****:*****@ViewBag.ConfirmationLink", url);
body = body.ToString();
BuildEmail("Your Account Is Successfully Created", body, RegInfo.Email);
}
/// <summary>
/// delete the given UserSite from database
/// </summary>
/// <param name="userSite"></param>
/// <returns>number of influenced row</returns>
public int DeleteUserSite(UserSite userSite)
{
string sqlQuery = "DELETE FROM [dbo].[UserSites] WHERE [Username]=@username AND [Sitename]=@sitename AND [Siteurl]=@siteurl";
SqlParameter[] param =
{
new SqlParameter("@username", userSite.username),
new SqlParameter("@sitename", userSite.siteName),
new SqlParameter("@siteurl", userSite.siteUrl),
};
return(DBHelper.ExecuteNonQuery(sqlQuery, param));
}
public IHttpActionResult PutSite(int id, Site site)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != site.ID)
{
return(BadRequest());
}
if (!Global.CheckUserIDAndPasswordWithSiteID(db, site.UILoginUserID, site.UILoginPassword, site.ID, "PutSite"))
{
return(BadRequest());
}
UserSite userSite = db.UserSites.Where(u => u.SiteID == site.ID && u.UserID == site.UILoginUserID).SingleOrDefault();
if (userSite == null)
{
return(BadRequest());
}
User user = db.Users.Find(site.UILoginUserID);
if (user == null)
{
return(BadRequest());
}
if (!user.IsSiteAdmin && !user.IsRootUser)
{
return(BadRequest());
}
db.Entry(site).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SiteExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// give a UserSite object and save to database
/// </summary>
/// <param name="userSite">a UserSite object</param>
/// <returns>number of influenced row</returns>
public int AddUserSite(UserSite userSite)
{
string sqlQuery = @"INSERT INTO [dbo].[UserSites] ([Username], [Sitename], [Siteurl]) VALUES
(@username, @siteName, @siteUrl) ";
SqlParameter[] param =
{
new SqlParameter("@Username", userSite.username),
new SqlParameter("@siteName", userSite.siteName),
new SqlParameter("@siteUrl", userSite.siteUrl),
};
return(DBHelper.ExecuteNonQuery(sqlQuery, param));
}
public JsonResult CheckValidUser(UserSite model)
{
string result = "Fail";
UserSite DataItem = _Context.newUser.Where(x => x.Email == model.Email && x.Password == model.Password).SingleOrDefault();
if (DataItem == null)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
Session["UserID"] = DataItem.ID.ToString();
Session["UserName"] = DataItem.UserName.ToString();
result = "Success";
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Add a siteInfo to database
/// </summary>
/// <param name="username"></param>
/// <param name="siteName"></param>
/// <param name="siteUrl"></param>
/// <returns>
/// 0: ok
/// -1: internal error
/// 1: nothing added
/// </returns>
public int AddUserSite(string username, string siteName, string siteUrl)
{
if (siteName == null || siteName.Trim() == string.Empty)
{
return(-1);
}
if (siteUrl == null || siteUrl.Trim() == string.Empty)
{
return(-1);
}
UserSite newUserSite = new UserSite
{
username = username,
siteName = siteName,
siteUrl = siteUrl
};
UserSiteService userSiteService = new UserSiteService();
//check if this site has been saved to this user:
UserSite savedUserSite = userSiteService.GetUserSitesByUsernameSitenameSiteurl(username, siteName, siteUrl);
if (savedUserSite != null)
{
return(1);
}
// add to database
int result = userSiteService.AddUserSite(newUserSite);
if (result == 1)
{
return(0);
}
else if (result == 0)
{
return(1);
}
else
{
return(-1);
}
}
public DecidirConnector(int ambiente, string privateApiKey, string publicApiKey)
{
this.ambiente = ambiente;
this.privateApiKey = privateApiKey;
this.publicApiKey = publicApiKey;
if (ambiente == Ambiente.AMBIENTE_PRODUCCION)
{
this.endpoint = endPointProduction;
}
else
{
this.endpoint = endPointSandbox;
}
this.healthCheckService = new HealthCheck(this.endpoint);
this.paymentService = new Payments(this.endpoint, this.privateApiKey);
this.userSiteService = new UserSite(this.endpoint, this.privateApiKey);
this.cardTokensService = new CardTokens(this.endpoint, this.privateApiKey);
}
/// <summary>
/// add default sites to database of this username
/// used for new registered users
/// read web.config to get the sites
/// Settings for this part is defined in Web.config/DefaultSites - a custom section
/// </summary>
/// <param name="username"></param>
/// <returns>number of sites that is added successfully</returns>
public int AddDefaultSites(string username)
{
int result = 0;
UserSiteService userSiteService = new UserSiteService();
DefaultSites defaultSites = (DefaultSites)ConfigurationManager.GetSection("DefaultSites");
foreach (DefaultSiteSetting site in defaultSites.KeyValues)
{
UserSite defaultUserSite = new UserSite
{
username = username,
siteName = site.Key,
siteUrl = site.Value,
};
result += userSiteService.AddUserSite(defaultUserSite);
}
return(result);
}
public long CreateUpdateUserSite(UserSiteModel model)
{
using (var db = new PCVEntities())
{
if (model != null)
{
var myModel = new UserSite();
myModel.SiteId = model.SiteId;
myModel.UserId = model.UserId;
myModel.RoleId = model.RoleId;
myModel.InActive = model.InActive;
if (model.Id > 0)
{
myModel.Id = model.Id.To <long>();
myModel.UpdatedDate = DateTime.Now;
myModel.UpdatedBy = MySession.Current.UserName;
db.Entry(myModel).State = EntityState.Modified;
}
else
{
myModel.CreatedDate = DateTime.Now;
myModel.CreatedBy = MySession.Current.UserName;
db.UserSite.Add(myModel);
}
db.SaveChanges();
if (myModel.Id > 0)
{
return(myModel.Id);
}
else
{
return(0);
}
}
return(0);
}
}
/// <summary>
/// 修改地址
/// </summary>
/// <param name="usite"></param>
/// <returns></returns>
public ActionResult SiteUp(UserSite usite)
{
UserSite oldusite = new UserSiteManager().GetEntitysWhereAsNoTracking(x => x.Id == usite.Id).FirstOrDefault();
oldusite.QuXianId = usite.QuXianId;
oldusite.SiteDetail = usite.SiteDetail;
oldusite.SitePhone = usite.SitePhone;
oldusite.SiteProName = usite.SiteProName;
UserSite uspro = new UserSiteManager().GetEntitysWhereAsNoTracking(x => x.SitePre == 1 & x.Id == usite.Id).FirstOrDefault();
if (uspro == null)
{
oldusite.SitePre = usite.SitePre;
}
if (new UserSiteManager().Update(oldusite))
{
if (oldusite.SitePre == 1)
{
UserSite us = new UserSiteManager().GetEntitysWhereAsNoTracking(x => x.SitePre == 1 & x.Id != oldusite.Id).FirstOrDefault();
if (us != null)
{
us.SitePre = 0;
if (new UserSiteManager().Update(us))
{
return(Json("1001", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("1000", JsonRequestBehavior.AllowGet));
}
}
}
return(Json("1001", JsonRequestBehavior.AllowGet));
}
return(Json("1000", JsonRequestBehavior.AllowGet));
}
private void init(int ambiente, string privateApiKey, string publicApiKey, string validateApiKey, string merchant)
{
this.privateApiKey = privateApiKey;
this.publicApiKey = publicApiKey;
this.validateApiKey = validateApiKey;
this.merchant = merchant;
if (ambiente == Ambiente.AMBIENTE_PRODUCCION)
{
this.endpoint = endPointProduction;
this.request_host = request_host_production;
}
else if (ambiente == Ambiente.AMBIENTE_SANDBOX)
{
this.endpoint = endPointSandbox;
this.request_host = request_host_sandbox;
}
this.healthCheckService = new HealthCheck(this.endpoint);
this.paymentService = new Payments(this.endpoint, this.privateApiKey, this.validateApiKey, this.merchant, this.request_host, this.publicApiKey);
this.userSiteService = new UserSite(this.endpoint, this.privateApiKey);
this.cardTokensService = new CardTokens(this.endpoint, this.privateApiKey);
}
//地址新增
public ActionResult SiteAdd(UserSite info)
{
var user = Session["USER"] as User;
info.UserId = user.Id;
info.SitePre = 0;
if (new UserSiteManager().Insert(info))
{
var info1 = new
{
msg = 1001
};
return(Json(info1, JsonRequestBehavior.AllowGet));
}
else
{
var info1 = new
{
msg = 1000
};
return(Json(info1, JsonRequestBehavior.AllowGet));
}
}
public EmptyResult ReloadPage(UserSite _site, bool _redirectToHome = false)
{
// M.Orlando: When user is on Compliance page (http://localhost:49179/Corporate/Home/Index),
// this is where code POSTS back to the server when the user selects different site.
var menuService = new JCR.Reports.Services.MenuService();
menuService.SaveArg(AppSession.UserID.GetValueOrDefault(), "SiteID", _site.SiteID.ToString());
//menuService.SaveArg(AppSession.UserID.GetValueOrDefault(), "SiteName", _site.SiteFullName.ToString());
//menuService.RefreshUserMenuState(AppSession.UserID.GetValueOrDefault());
if (_redirectToHome)
{
return(new EmptyResult());
}
var commonService = new CommonService();
AppSession.SelectedSiteId = _site.SiteID;
AppSession.SelectedSiteName = _site.SiteFullName;
AppSession.IsCorporateSite = commonService.CheckCorporateAccess(AppSession.SelectedSiteId);
AppSession.HasTracersAccess = _site.IsTracersAccess == 1 ? true : false;
CMSService.UpdateCMSSessionValue();
SearchInputService reportService = new SearchInputService();
var lstPrograms = AppSession.Sites.Where(m => m.SiteID == AppSession.SelectedSiteId).FirstOrDefault().Programs;
//Set the default program when the site is changed
reportService.SetProgramPreference(lstPrograms);
return(new EmptyResult());
}
/// <summary>
/// Delete a siteInfo from database
/// </summary>
/// <param name="username"></param>
/// <param name="siteName"></param>
/// <param name="siteUrl"></param>
/// <returns>
/// 0: ok
/// -1: internal error
/// 1: nothing deleted
/// </returns>
public int DeleteUserSite(string username, string siteName, string siteUrl)
{
if (siteName == null || siteName.Trim() == string.Empty)
{
return(-1);
}
if (siteUrl == null || siteUrl.Trim() == string.Empty)
{
return(-1);
}
UserSite userSiteToDelete = new UserSite
{
username = username,
siteName = siteName,
siteUrl = siteUrl
};
UserSiteService userSiteService = new UserSiteService();
// delete from database
int result = userSiteService.DeleteUserSite(userSiteToDelete);
if (result == 1)
{
return(0);
}
else if (result == 0)
{
return(1);
}
else
{
return(-1);
}
}
public GuestUserInfo()
{
UserSiteInfo = new UserSite();
}
public static async Task SeedData(PikeSafetyDbContext context, UserManager <AppUser> userManager, RoleManager <AppRole> roleManager)
{
if (!context.Companies.Any())
{
var companies = new List <Company>
{
new Company
{
Name = "Ashton Woods Atlanta",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Company
{
Name = "Pike Consulting",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Company
{
Name = "Chafin Home Builders",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Company
{
Name = "Fake Testing Company",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = false
}
};
await context.Companies.AddRangeAsync(companies);
await context.SaveChangesAsync();
}
var PikeConsultingId = await context.Companies.Where(x => x.Name == "Pike Consulting").Select(x => x.Id).FirstOrDefaultAsync();
var AshtonWoodsAtlantaId = await context.Companies.Where(x => x.Name == "Ashton Woods Atlanta").Select(x => x.Id).FirstOrDefaultAsync();
var ChafinHomeBuildersId = await context.Companies.Where(x => x.Name == "Chafin Home Builders").Select(x => x.Id).FirstOrDefaultAsync();
var FakeTestingCompanyId = await context.Companies.Where(x => x.Name == "Fake Testing Company").Select(x => x.Id).FirstOrDefaultAsync();
if (!context.Sites.Any())
{
var sites = new List <Site>
{
new Site
{
CompanyId = PikeConsultingId,
Name = "Pike Community",
Address = "101 Devant St. Fayetteville, GA 30214",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = PikeConsultingId,
Name = "Century Communities Projects",
Address = null,
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = PikeConsultingId,
Name = "Lennar Homes",
Address = null,
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = PikeConsultingId,
Name = "Ashton Woods",
Address = null,
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = PikeConsultingId,
Name = "Piedmont Residential",
Address = null,
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = PikeConsultingId,
Name = "test tkxel",
Address = "31 B-III, Gulberg III, Ali Zeb Road",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = AshtonWoodsAtlantaId,
Name = "Adair Manor",
Address = "7325 Kemper Rd, Johns Creek, GA 30097",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = AshtonWoodsAtlantaId,
Name = "Aria North",
Address = "740 Abernathy Rd NE, Sandy Springs, GA 30328",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = AshtonWoodsAtlantaId,
Name = "Aria West",
Address = "6560 Glenridge Dr Sandy Springs, GA 30328",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = AshtonWoodsAtlantaId,
Name = "Aria South",
Address = "Canopy Drive Sandy Springs, GA 30328",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Brighton Park",
Address = "1242 Maddox Rd, Houschton, GA 30548",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Hills at Hamilton Mill",
Address = "3140 Hog Mountain Rd NE Dacula, GA 30019",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Jacob's Creek",
Address = "3826 Claude Brewer Rd, Loganville, GA 30052, USA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Jameson Glen",
Address = "Twin Lakes Rd, GA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Auburn Station",
Address = "1800 Highway 29 (Atlanta Highway Northwest)",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Mallard Landing",
Address = "310 Drake Drive, Jefferson, GA, USA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Mulberry Park",
Address = "7090 Silk Tree Pointe Braselton, Georgia 30517",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Mundy Mill",
Address = "Millside Parkway, Gainesville, GA 30504, USA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Paden Ridge",
Address = "537 Paden Dr, Lawrenceville, GA 30044, United States",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Settles Bridge",
Address = "513 Nichols Drive, Suwanee, GA, USA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Stonehaven",
Address = "2756 Dolostone Way, Dacula, GA 30019, USA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Stonewater Creek",
Address = "2027 Stone Water Court Houschton, Georgia 30548",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Suwanee Overlook",
Address = "9456 Settles Rd, Suwanee, GA 30024, USA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Turnbridge",
Address = "Mc Gee Rd SW, Snellville, GA 30078, USA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Villages at Ivy Creek",
Address = "2979 Gravel Springs Rd, Buford, GA",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Parkside at Mulberry",
Address = null,
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = ChafinHomeBuildersId,
Name = "Creekside at Hamilton Mill",
Address = null,
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = true,
},
new Site
{
CompanyId = FakeTestingCompanyId,
Name = "Fake Testing Site",
Address = "123 Fake Drive Testy, AL 12345",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = DateTime.UtcNow,
UpdatedBy = "Seed Data",
IsActive = false
}
};
await context.Sites.AddRangeAsync(sites);
await context.SaveChangesAsync();
}
var StonewaterCreekSiteId = await context.Sites.Where(x => x.Name == "Stonewater Creek").Select(x => x.Id).FirstOrDefaultAsync(); //site for ChafinHomeBuildersId
var JamesonGlenSiteId = await context.Sites.Where(x => x.Name == "Jameson Glen").Select(x => x.Id).FirstOrDefaultAsync(); //site for ChafinHomeBuildersId
var AshtonWoodsSiteId = await context.Sites.Where(x => x.Name == "Ashton Woods").Select(x => x.Id).FirstOrDefaultAsync(); //site for PikeConsultingId
var AriaSouthSiteId = await context.Sites.Where(x => x.Name == "Aria South").Select(x => x.Id).FirstOrDefaultAsync(); //site for AshtonWoodsAtlantaId
if (!roleManager.Roles.Any())
{
var roles = new List <AppRole>
{
new AppRole
{
Name = RoleNames.Admin,
Description = "This role has access to all application features and can access all data without exceptions.",
PrivilegeLevel = 100
},
new AppRole
{
Name = RoleNames.AreaManager,
Description = "This role has access to all application features and can access all data pertaining to their company.",
PrivilegeLevel = 50
},
new AppRole
{
Name = RoleNames.ConstructionSupervisor,
Description = "This role has access to all application features and can access all data pertaining to their company.",
PrivilegeLevel = 50
},
new AppRole
{
Name = RoleNames.Executive,
Description = "This role has access to all application features and can access all data pertaining to their company.",
PrivilegeLevel = 50,
},
new AppRole
{
Name = RoleNames.Inspector,
Description = "This role has limited access to application features and can only access data pertaining to theirself.",
PrivilegeLevel = 10
}
};
foreach (var role in roles)
{
await roleManager.CreateAsync(role);
}
}
if (!userManager.Users.Any())
{
var users = new List <AppUser>
{
new AppUser
{
UserName = "******",
FirstName = "Daniel",
LastName = "Morgan",
Email = "*****@*****.**",
CompanyId = ChafinHomeBuildersId,
IsActive = true,
EmailConfirmed = true
},
new AppUser
{
UserName = "******",
FirstName = "Dan",
LastName = "Hoffman",
Email = "*****@*****.**",
CompanyId = ChafinHomeBuildersId,
IsActive = true,
EmailConfirmed = true
},
new AppUser
{
UserName = "******",
FirstName = "David",
LastName = "Hasselhoff",
Email = "*****@*****.**",
CompanyId = PikeConsultingId,
IsActive = true,
EmailConfirmed = true
},
new AppUser
{
UserName = "******",
FirstName = "Sally",
LastName = "Miller",
Email = "*****@*****.**",
CompanyId = PikeConsultingId,
IsActive = false,
EmailConfirmed = true
},
new AppUser
{
UserName = "******",
FirstName = "Inspector",
LastName = "McTesterface",
Email = "*****@*****.**",
CompanyId = AshtonWoodsAtlantaId,
IsActive = true,
EmailConfirmed = true
}
};
var registerDateClaim = new Claim("RegisterationDate", DateTime.UtcNow.ToShortDateString());
foreach (var user in users)
{
var result = await userManager.CreateAsync(user, "Pa$$w0rd");
if (result.Succeeded)
{
var newUser = await userManager.FindByEmailAsync(user.Email);
var userSite = new UserSite {
AppUserId = newUser.Id, SiteId = context.Sites.FirstOrDefault(x => x.CompanyId == newUser.CompanyId).Id
};
if (user.FirstName == "Inspector")
{
await userManager.AddToRoleAsync(newUser, RoleNames.Inspector);
await userManager.AddClaimAsync(newUser, registerDateClaim);
await context.UserSites.AddAsync(userSite);
await context.SaveChangesAsync();
continue;
}
if (user.LastName == "Hasselhoff")
{
await userManager.AddToRoleAsync(newUser, RoleNames.AreaManager);
await userManager.AddClaimAsync(newUser, registerDateClaim);
await context.UserSites.AddAsync(userSite);
await context.SaveChangesAsync();
continue;
}
await userManager.AddToRoleAsync(newUser, RoleNames.Admin);
await userManager.AddClaimAsync(newUser, registerDateClaim);
await context.UserSites.AddAsync(userSite);
await context.SaveChangesAsync();
}
}
}
var DghoffmanUser = await userManager.FindByEmailAsync("*****@*****.**");
var CdmorganUser = await userManager.FindByEmailAsync("*****@*****.**");
if (!context.ReportTypes.Any())
{
var reportTypes = new List <ReportType>
{
new ReportType
{
Id = 1,
Title = "New User",
RequireImages = false,
Fields = JsonSerializer.Serialize(new List <ReportTypeField>
{
new ReportTypeField
{
Type = "Dropdown",
Name = "Title",
Placeholder = "Select Title",
Options = "Mr, Mrs, Ms, Miss",
Required = false,
Value = ""
},
new ReportTypeField
{
Type = "Text",
Name = "First Name",
Placeholder = "Input first name",
Options = "",
Required = true,
Value = ""
},
new ReportTypeField
{
Type = "Text",
Name = "Last Name",
Placeholder = "Input last name",
Options = "",
Required = true,
Value = ""
},
new ReportTypeField
{
Type = "Radio",
Name = "Gender",
Placeholder = "",
Options = "Male, Female, Both",
Required = true,
Value = ""
},
new ReportTypeField
{
Type = "Textarea",
Name = "Comments",
Placeholder = "Add comments...",
Options = "",
Required = false,
Value = ""
},
new ReportTypeField
{
Type = "Checkbox",
Name = "Acknowledgment",
Placeholder = "I agree to the Terms of Service",
Options = "",
Required = true,
Value = ""
},
}
),
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = null,
UpdatedBy = null,
IsActive = true
}
};
await context.ReportTypes.AddRangeAsync(reportTypes);
await context.SaveChangesAsync();
}
if (!context.Reports.Any())
{
var reports = new List <Report>
{
new Report
{
Title = "Added McTesterface",
ReportType = "New User",
ReportTypeId = 1,
ReportFields = JsonSerializer.Serialize(new List <ReportField>
{
new ReportField
{
Type = "Dropdown",
Name = "Title",
Placeholder = "Select Title",
Options = "Mr, Mrs, Ms, Miss",
Required = false,
Value = "Mr"
},
new ReportField
{
Type = "Text",
Name = "First Name",
Placeholder = "Input first name",
Options = "",
Required = true,
Value = "Tester"
},
new ReportField
{
Type = "Text",
Name = "Last Name",
Placeholder = "Input last name",
Options = "",
Required = true,
Value = "McTesterface"
},
new ReportField
{
Type = "Radio",
Name = "Gender",
Placeholder = "",
Options = "Male, Female, Both",
Required = true,
Value = "Male"
},
new ReportField
{
Type = "Textarea",
Name = "Comments",
Placeholder = "Add comments...",
Options = "",
Required = false,
Value = "McTesterfaces Rule!"
},
new ReportField
{
Type = "Checkbox",
Name = "Acknowledgment",
Placeholder = "I agree to the Terms of Service",
Options = "",
Required = true,
Value = "true"
},
}
),
CompletionPercentage = 100,
RequireImages = false,
CompanyId = ChafinHomeBuildersId,
CompanyName = "Chafin Home Builders",
SiteId = StonewaterCreekSiteId,
SiteName = "Stonewater Creek",
CreatedOn = DateTime.UtcNow,
CreatedBy = "Seed Data",
UpdatedOn = null,
UpdatedBy = null,
IsActive = true
}
};
await context.Reports.AddRangeAsync(reports);
await context.SaveChangesAsync();
}
}
public ActionResult Confirm(UserSite reginfo)
{
ViewBag.regID = reginfo.ID;
return(View());
}
/// <summary>
/// There are no comments for UserSite in the schema.
/// </summary>
public void AddToUserSite(UserSite userSite)
{
base.AddObject("UserSite", userSite);
}
/// <summary>
/// Create a new UserSite object.
/// </summary>
/// <param name="userSiteID">Initial value of UserSiteID.</param>
public static UserSite CreateUserSite(int userSiteID)
{
UserSite userSite = new UserSite();
userSite.UserSiteID = userSiteID;
return userSite;
}
public void Add(UserSite userSite)
{
_context.UserSites.Add(userSite);
}
