protected void Wizard1_ActiveStepChanged(object sender, EventArgs e)
{
//get the listview in the wizard
System.Web.UI.WebControls.ListView list = (Wizard1.FindControl("sideBarList") as System.Web.UI.WebControls.ListView);
//get the ul in the listview and change its cssclass according to the activestepindex of wizard
HtmlGenericControl ul = list.FindControl("ul") as HtmlGenericControl;
if (Wizard1.ActiveStepIndex == 0)
{
ul.Attributes.Add("class", "sidebar1");
Wizard wizard = Wizard1;
//get the wizardstep
WizardStep wizardStep1 = Wizard1.FindControl("WizardStep1") as WizardStep;
//get the div control in the wizardstep and change its class
HtmlGenericControl step1 = wizardStep1.FindControl("step1") as HtmlGenericControl;
step1.Attributes.Add("class", "step1 ");
}
else
{
ul.Attributes.Add("class", "sidebar2");
WizardStep wizardStep2 = Wizard1.FindControl("WizardStep2") as WizardStep;
HtmlGenericControl step2 = wizardStep2.FindControl("step2") as HtmlGenericControl;
step2.Attributes.Add("class", "step2");
}
}
protected void CreateNewUserButton_Click(object sender, EventArgs e)
{
MultiView1.SetActiveView(CreateNewUserView);
WizardStep AdditionalInfo = RegisterUser.FindControl("AdditionalInfo") as WizardStep;
CheckBoxList RoleList = AdditionalInfo.FindControl("RoleList") as CheckBoxList;
RoleList.DataSource = Roles.GetAllRoles();
RoleList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Reference the SpecifyRolesStep WizardStep
WizardStep SpecifyRolesStep = RegisterUserWithRoles.FindControl("SpecifyRolesStep") as WizardStep;
// Reference the RoleList CheckBoxList
CheckBoxList RoleList = SpecifyRolesStep.FindControl("RoleList") as CheckBoxList;
// Bind the set of roles to RoleList
RoleList.DataSource = Roles.GetAllRoles();
RoleList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Reference the SpecifyRolesStep WizardStep
WizardStep SpecifyRolesStep = RegisterUserWithRoles.FindControl("SpecifyRolesStep") as WizardStep;
// Reference the RoleList CheckBoxList
DropDownList RoleList = SpecifyRolesStep.FindControl("RoleList") as DropDownList;
// Bind the set of roles to RoleList
RoleList.Items.Add(new ListItem("Basic 99kr/month", "Basic"));
RoleList.Items.Add(new ListItem("Plus 199kr/month", "Plus"));
RoleList.Items.Add(new ListItem("Prime 499kr/month", "Prime"));
RoleList.DataBind();
}
}
protected void NewUserWizard_ActiveStepChanged(object sender, EventArgs e)
{
// Have we JUST reached the Complete step?
if (NewUserWizard.ActiveStep.Title == "Complete")
{
WizardStep UserSettings = NewUserWizard.FindControl("UserSettings") as WizardStep;
// Programmatically reference the TextBox controls
//TextBox HomeTown = UserSettings.FindControl("HomeTown") as TextBox;
//TextBox HomepageUrl = UserSettings.FindControl("HomepageUrl") as TextBox;
//TextBox Signature = UserSettings.FindControl("Signature") as TextBox;
///////////////////////////////////////////////////////////////////////////////
TextBox FirstName = UserSettings.FindControl("FirstName") as TextBox;
TextBox LastName = UserSettings.FindControl("LastName") as TextBox;
TextBox Mobile = UserSettings.FindControl("Mobile") as TextBox;
TextBox Country = UserSettings.FindControl("Country") as TextBox;
TextBox City = UserSettings.FindControl("City") as TextBox;
TextBox Address = UserSettings.FindControl("Address") as TextBox;
//TextBox picture = UserSettings.FindControl("picture") as TextBox;
///////////////////////////////////////////////////////////////////////////////
// Update the UserProfiles record for this user
// Get the UserId of the just-added user
MembershipUser newUser = Membership.GetUser(NewUserWizard.UserName);
Guid newUserId = (Guid)newUser.ProviderUserKey;
// Insert a new record into UserProfiles
// string connectionString = ConfigurationManager.ConnectionStrings["SecurityTutorialsConnectionString"].ConnectionString;
string updateSql = "UPDATE custom_profile SET firstname=@firstname,lastname=@lastname,mobile=@mobile,country=@country,city=@city,address=@address,picture=@picture where userid='" + newUserId + "'";
using (SqlConnection conn = Connection_Manger.getConnection())
{
conn.Open();
SqlCommand myCommand = new SqlCommand(updateSql, conn);
myCommand.Parameters.AddWithValue("@firstname", FirstName.Text.Trim());
myCommand.Parameters.AddWithValue("@lastname", LastName.Text.Trim());
myCommand.Parameters.AddWithValue("@mobile", Mobile.Text.Trim());
myCommand.Parameters.AddWithValue("@country", Country.Text.Trim());
myCommand.Parameters.AddWithValue("@city", City.Text.Trim());
myCommand.Parameters.AddWithValue("@address", Address.Text.Trim());
myCommand.Parameters.AddWithValue("@picture", DBNull.Value);
myCommand.ExecuteNonQuery();
conn.Close();
}
}
}
protected void RegisterUser_ActiveStepChanged(object sender, EventArgs e)
{
// Have we JUST reached the Complete step?
if (RegisterUser.ActiveStep.Title == "Complete")
{
// Reference the SpecifyRolesStep WizardStep
WizardStep SpecifyRolesStep = RegisterUser.FindControl("SpecifyRolesStep") as WizardStep;
// Reference the RoleList CheckBoxList
CheckBoxList RoleList = SpecifyRolesStep.FindControl("RoleList") as CheckBoxList;
// Add the checked roles to the just-added user
foreach (ListItem li in RoleList.Items)
{
if (li.Selected)
{
Roles.AddUserToRole(RegisterUser.UserName, li.Text);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (!User.IsInRole("SysAdmin"))
//{
// Response.Redirect("~/AccessDenied.aspx", true);
//}
if (!Page.IsPostBack)
{
// Reference the SpecifyRolesStep WizardStep
WizardStep SpecifyRolesStep = RegisterUser.FindControl("SpecifyRolesStep") as WizardStep;
// Reference the RoleList CheckBoxList
CheckBoxList RoleList = SpecifyRolesStep.FindControl("RoleList") as CheckBoxList;
// Bind the set of roles to RoleList
RoleList.DataSource = Roles.GetAllRoles();
RoleList.DataBind();
}
}
protected void CreateUser_ActiveStepChanged(object sender, EventArgs e)
{
if (CreateUser.ActiveStep.Title == "Gotowe")
{
WizardStep UserInfo = CreateUser.FindControl("AdditionalInfo") as WizardStep;
TextBox Name = UserInfo.FindControl("NameTB") as TextBox;
TextBox Town = UserInfo.FindControl("TownTB") as TextBox;
TextBox Street = UserInfo.FindControl("StreetTB") as TextBox;
TextBox StreetNumber = UserInfo.FindControl("StreetNumberTB") as TextBox;
TextBox PostalCode = UserInfo.FindControl("PostalCodeTB") as TextBox;
Calendar DateOfBirth = UserInfo.FindControl("DateOfBirth") as Calendar;
MembershipUser newUser = Membership.GetUser(CreateUser.UserName);
Guid newUserId = (Guid)newUser.ProviderUserKey;
string connectingString = ConfigurationManager.ConnectionStrings["BBB"].ConnectionString;
string updateUrl = "INSERT INTO UserProfiles(NameAndSurname, Town, Street, StreetNumber, PostalCode, DateOfBirth, UserId) VALUES (@NameAndSurname, @Town, @Street, @StreetNumber, @PostalCode, @UserId)";
using (SqlConnection myConnection = new SqlConnection(connectingString))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(updateUrl, myConnection);
myCommand.Parameters.AddWithValue("@NameAndSurname", Name.Text.Trim());
myCommand.Parameters.AddWithValue("@Town", Town.Text.Trim());
myCommand.Parameters.AddWithValue("@Street", Street.Text.Trim());
myCommand.Parameters.AddWithValue("@StreetNumber", StreetNumber.Text.Trim());
myCommand.Parameters.AddWithValue("@PostalCode", PostalCode.Text.Trim());
myCommand.Parameters.AddWithValue("@DateOfBirth", DateOfBirth.SelectedDate);
myCommand.Parameters.AddWithValue("@UserId", newUserId);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
string userName = CreateUser.UserName;
Roles.AddUserToRole(userName, "patient");
}
}
protected void RegisterUser_ActiveStepChanged(object sender, EventArgs e)
{
if (RegisterUser.ActiveStep.Title == "Gotowe")
{
WizardStep SpecifyRolesStep = RegisterUser.FindControl("AdditionalInfo") as WizardStep;
CheckBoxList RoleList = SpecifyRolesStep.FindControl("RoleList") as CheckBoxList;
string userName = RegisterUser.UserName;
foreach (ListItem li in RoleList.Items)
{
if (li.Selected)
{
Roles.AddUserToRole(userName, li.Text);
}
}
if (Roles.IsUserInRole(userName, "doctor"))
{
string connectingStringAddDoctor = ConfigurationManager.ConnectionStrings["BBB"].ConnectionString;
string addDoctorUrl = "INSERT INTO Cadre(UserId) VALUES (@UserId)";
MembershipUser newDoctor = Membership.GetUser(userName);
Guid newDoctorId = (Guid)newDoctor.ProviderUserKey;
using (SqlConnection myConnection = new SqlConnection(connectingStringAddDoctor))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(addDoctorUrl, myConnection);
myCommand.Parameters.AddWithValue("@UserId", newDoctorId);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
WizardStep UserInfo = RegisterUser.FindControl("AdditionalInfo") as WizardStep;
TextBox Name = UserInfo.FindControl("NameTB") as TextBox;
TextBox Town = UserInfo.FindControl("TownTB") as TextBox;
TextBox Street = UserInfo.FindControl("StreetTB") as TextBox;
TextBox StreetNumber = UserInfo.FindControl("StreetNumberTB") as TextBox;
TextBox PostalCode = UserInfo.FindControl("PostalCodeTB") as TextBox;
String calendar = DateOfBirth.SelectedDate.Year.ToString() + "-" + DateOfBirth.SelectedDate.Month.ToString() + "-" + DateOfBirth.SelectedDate.Day.ToString();
MembershipUser newUser = Membership.GetUser(RegisterUser.UserName);
Guid newUserId = (Guid)newUser.ProviderUserKey;
string connectingString = ConfigurationManager.ConnectionStrings["BBB"].ConnectionString;
string updateUrl = "INSERT INTO UserProfiles(NameAndSurname, Town, Street, StreetNumber, PostalCode, DateOfBirth, UserId) VALUES (@NameAndSurname, @Town, @Street, @StreetNumber, @PostalCode, @DateOfBirth, @UserId)";
using (SqlConnection myConnection = new SqlConnection(connectingString))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(updateUrl, myConnection);
myCommand.Parameters.AddWithValue("@NameAndSurname", Name.Text.Trim());
myCommand.Parameters.AddWithValue("@Town", Town.Text.Trim());
myCommand.Parameters.AddWithValue("@Street", Street.Text.Trim());
myCommand.Parameters.AddWithValue("@StreetNumber", Int32.Parse(StreetNumber.Text.Trim()));
myCommand.Parameters.AddWithValue("@PostalCode", PostalCode.Text.Trim());
myCommand.Parameters.AddWithValue("@DateOfBirth", calendar);
myCommand.Parameters.AddWithValue("@UserId", newUserId);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
}
protected void RegisterUser_ActiveStepChanged(object sender, EventArgs e)
{
// Have we JUST reached the Complete step?
if (RegisterUser.ActiveStep.Title == "Complete")
{
WizardStep ProfileData = RegisterUser.FindControl("ProfileData") as WizardStep;
// Programmatically reference the TextBox controls
TextBox txtFullName = ProfileData.FindControl("txtFullName") as TextBox;
DropDownList ddlGender = ProfileData.FindControl("ddlGender") as DropDownList;
TextBox txtAge = ProfileData.FindControl("txtAge") as TextBox;
TextBox txtCareer = ProfileData.FindControl("txtCareer") as TextBox;
TextBox txtCareerDescription = ProfileData.FindControl("txtCareerDescription") as TextBox;
// Update the UserProfiles record for this user
// Get the UserId of the just-added user
MembershipUser newUser = Membership.GetUser(RegisterUser.UserName);
Guid newUserId = (Guid)newUser.ProviderUserKey;
// Insert a new record into UserProfiles
string connectionString =
ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string updateSql = "UPDATE UserProfiles SET FullName = @FullName, Gender = @Gender, Age = @Age, Career = @Career, CareerDescription = @CareerDescription WHERE UserId = @UserId";
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(updateSql, myConnection);
myCommand.Parameters.AddWithValue("@FullName", txtFullName.Text.Trim());
myCommand.Parameters.AddWithValue("@Gender", ddlGender.SelectedItem.Text.Trim());
myCommand.Parameters.AddWithValue("@Age", txtAge.Text.Trim());
myCommand.Parameters.AddWithValue("@Career", txtCareer.Text.Trim());
myCommand.Parameters.AddWithValue("@CareerDescription", txtCareerDescription.Text.Trim());
myCommand.Parameters.AddWithValue("@UserId", newUserId);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
string connectionString2 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string insertSql = "INSERT INTO PhotoAlbums(Name, UserId) VALUES(@Name, @UserId)";
using (SqlConnection myConnection = new SqlConnection(connectionString2))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(insertSql, myConnection);
myCommand.Parameters.AddWithValue("@UserId", newUserId);
myCommand.Parameters.AddWithValue("@Name", "ProfilePictures");
myCommand.ExecuteNonQuery();
myConnection.Close();
}
string connectionString3 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string insertSql2 = "INSERT INTO PhotoAlbums(Name, UserId) VALUES(@Name, @UserId)";
using (SqlConnection myConnection = new SqlConnection(connectionString3))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(insertSql2, myConnection);
myCommand.Parameters.AddWithValue("@UserId", newUserId);
myCommand.Parameters.AddWithValue("@Name", "CoverPhotos");
myCommand.ExecuteNonQuery();
myConnection.Close();
}
//string connectionString4 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
//string insertSql3 = "INSERT INTO UserCircles(Name, UserId) VALUES(@Name, @UserId)";
//using (SqlConnection myConnection = new SqlConnection(connectionString4))
//{
// myConnection.Open();
// SqlCommand myCommand = new SqlCommand(insertSql3, myConnection);
// myCommand.Parameters.AddWithValue("@UserId", newUserId);
// myCommand.Parameters.AddWithValue("@Name", "All");
// myCommand.ExecuteNonQuery();
// myConnection.Close();
//}
//using (SqlConnection myConnection = new SqlConnection(connectionString4))
//{
// myConnection.Open();
// SqlCommand myCommand = new SqlCommand(insertSql3, myConnection);
// myCommand.Parameters.AddWithValue("@UserId", newUserId);
// myCommand.Parameters.AddWithValue("@Name", "Friends");
// myCommand.ExecuteNonQuery();
// myConnection.Close();
//}
//using (SqlConnection myConnection = new SqlConnection(connectionString4))
//{
// myConnection.Open();
// SqlCommand myCommand = new SqlCommand(insertSql3, myConnection);
// myCommand.Parameters.AddWithValue("@UserId", newUserId);
// myCommand.Parameters.AddWithValue("@Name", "Family");
// myCommand.ExecuteNonQuery();
// myConnection.Close();
//}
//using (SqlConnection myConnection = new SqlConnection(connectionString4))
//{
// myConnection.Open();
// SqlCommand myCommand = new SqlCommand(insertSql3, myConnection);
// myCommand.Parameters.AddWithValue("@UserId", newUserId);
// myCommand.Parameters.AddWithValue("@Name", "Acquaintances");
// myCommand.ExecuteNonQuery();
// myConnection.Close();
//}
}
}
protected void CreateUserWizard1_ActiveStepChanged(object sender, EventArgs e)
{
if (CreateUserWizard1.ActiveStep.Title == "Your Photo")
{
WizardStep ProfileData = CreateUserWizard1.FindControl("ProfileData") as WizardStep;
// Update the UserProfiles record for this user
// Get the UserId of the just-added user
MembershipUser newUser = Membership.GetUser(CreateUserWizard1.UserName);
Guid newUserId = (Guid)newUser.ProviderUserKey;
// Insert a new record into UserProfiles
string connectionString =
ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string updateSql = "UPDATE UserProfiles SET City = @City, Hometown = @Hometown, School_College = @School_College, University = @University, Career = @Career, CareerDescription = @CareerDescription WHERE UserId = @UserId";
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(updateSql, myConnection);
myCommand.Parameters.AddWithValue("@City", ((TextBox)ProfileData.FindControl("City")).Text);
myCommand.Parameters.AddWithValue("@Hometown", ((TextBox)ProfileData.FindControl("Hometown")).Text);
myCommand.Parameters.AddWithValue("@School_College", ((TextBox)ProfileData.FindControl("School_College")).Text);
myCommand.Parameters.AddWithValue("@University", ((TextBox)ProfileData.FindControl("University")).Text);
myCommand.Parameters.AddWithValue("@Career", ((TextBox)ProfileData.FindControl("Career")).Text);
myCommand.Parameters.AddWithValue("@CareerDescription", ((TextBox)ProfileData.FindControl("CareerDescription")).Text);
myCommand.Parameters.AddWithValue("@UserId", newUserId);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
if (CreateUserWizard1.ActiveStep.Title == "Complete")
{
}
//string connectionString2 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
//string insertSql = "INSERT INTO PhotoAlbums(Name, UserId) VALUES(@Name, @UserId)";
//using (SqlConnection myConnection = new SqlConnection(connectionString2))
//{
// myConnection.Open();
// SqlCommand myCommand = new SqlCommand(insertSql, myConnection);
// myCommand.Parameters.AddWithValue("@UserId", newUserId);
// myCommand.Parameters.AddWithValue("@Name", "ProfilePictures");
// myCommand.ExecuteNonQuery();
// myConnection.Close();
//}
//string connectionString3 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
//string insertSql2 = "INSERT INTO PhotoAlbums(Name, UserId) VALUES(@Name, @UserId)";
//using (SqlConnection myConnection = new SqlConnection(connectionString3))
//{
// myConnection.Open();
// SqlCommand myCommand = new SqlCommand(insertSql2, myConnection);
// myCommand.Parameters.AddWithValue("@UserId", newUserId);
// myCommand.Parameters.AddWithValue("@Name", "CoverPhotos");
// myCommand.ExecuteNonQuery();
// myConnection.Close();
//}
}
}
