protected void Page_Load(object sender, EventArgs e)
{
var AllUser = from p in db.Users
select p;
var q = (from p in usm.aspnet_Roles
where p.RoleName == "Professor"
select p.RoleId).First();
var h = (from p in usm.aspnet_Roles
where p.RoleName == "Header"
select p.RoleId).First();
var d = (from p in usm.aspnet_Roles
where p.RoleName == "Dean"
select p.RoleId).First();
foreach (var item in AllUser)
{
var uName = (from p in usm.aspnet_Users
where p.UserName == item.UserName
select p.UserId).First();
try
{
var inRole = (from p in usm.aspnet_UsersInRoles
where p.UserId == uName
select p).First();
}
catch (Exception)
{
aspnet_UsersInRole ro = new aspnet_UsersInRole();
if (item.UserLevelId == 2)
{
ro.RoleId = q;
}
else if (item.UserLevelId == 1)
{
ro.RoleId = h;
}
else
{
ro.RoleId = d;
}
ro.UserId = uName;
usm.aspnet_UsersInRoles.InsertOnSubmit(ro);
usm.SubmitChanges();
}
}
}
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
FormsAuthentication.SetAuthCookie(RegisterUser.UserName, createPersistentCookie: false);
string email = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Email")).Text;
int dept = Convert.ToInt32(((DropDownList)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Dept")).SelectedValue);
int prefix = Convert.ToInt32(((DropDownList)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Prefix")).SelectedValue);
string firstName = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("FirstName")).Text;
string lastName = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("LastName")).Text;
User x = new User();
x.UserName = RegisterUser.UserName;
x.Email = email;
x.DeptId = dept;
x.PrefixId = prefix;
x.FirstName = firstName;
x.LastName = lastName;
x.StatusId = 0;
x.UserLevelId = 2;
db.Users.InsertOnSubmit(x);
db.SubmitChanges();
var q = (from p in usm.aspnet_Roles
where p.RoleName == "Professor"
select p.RoleId).First();
var uName = (from p in usm.aspnet_Users
where p.UserName == RegisterUser.UserName
select p.UserId).First();
aspnet_UsersInRole ro = new aspnet_UsersInRole();
ro.RoleId = q;
ro.UserId = uName;
usm.aspnet_UsersInRoles.InsertOnSubmit(ro);
usm.SubmitChanges();
string continueUrl = RegisterUser.ContinueDestinationPageUrl;
if (!OpenAuth.IsLocalUrl(continueUrl))
{
continueUrl = "~/";
}
Response.Redirect(continueUrl);
}
private void detach_aspnet_UsersInRoles(aspnet_UsersInRole entity)
{
this.SendPropertyChanging();
entity.aspnet_Role = null;
}
partial void Deleteaspnet_UsersInRole(aspnet_UsersInRole instance);
partial void Updateaspnet_UsersInRole(aspnet_UsersInRole instance);
partial void Insertaspnet_UsersInRole(aspnet_UsersInRole instance);
private void attach_aspnet_UsersInRoles(aspnet_UsersInRole entity)
{
this.SendPropertyChanging();
entity.aspnet_User = this;
}