public List <Classes.User> GetFriends()
{
if (newUser != null)
{
query = new Dictionary <string, List <string> >();
query.Add(sq.SQL_PROJECT, new List <String>()
{
sq.SQL_SELECT, c.FR_id
});
query.Add(sq.SQL_FROM, new List <String>()
{
sq.SQL_FROM, c.FR_table
});
query.Add(sq.SQL_WHERE, new List <String>()
{
c.FR_uid
});
query.Add(sq.SQL_COND, new List <String>()
{
newUser.user_Id
});
List <Object[]> newObject = newQuery.SQLSelectQuery(query);
var userList = new List <Classes.User>();
foreach (Object[] item in newObject)
{
var tempUser = new Classes.User()
{
user_Id = item[0].ToString()
};
userList.Add(tempUser);
}
return(userList);
}
return(null);
}
public InpatientAdmissionList(Classes.User user)
{
InitializeComponent();
currentUser = user;
InitList();
PopulateListView();
}
protected void Page_Load(object sender, EventArgs e)
{
Classes.User objUser = new Classes.User();
try
{
string activationCode = Request["code"].ToString();
string email = Request["email"].ToString();
if (objUser.getActivationCode(email) == activationCode)
{
objUser.setStatus(email, "Active");
litError.Text = "Your account is successfully activated";
}
else
litError.Text = "Invalid Account Activation Information Provided";
objUser.close();
}
catch(Exception ex)
{
litError.Text = "Invalid Account Activation Information Provided";
objUser.close();
}
}
public List <Object[]> GetFriends()
{
if (newUser != null)
{
Classes.User tempUser = new Classes.User();
List <Classes.User> tempUserList = new List <Classes.User>();
query = new Dictionary <string, List <string> >();
query.Add(sq.SQL_PROJECT, new List <String>()
{
sq.SQL_SELECT, c.FR_id
});
query.Add(sq.SQL_FROM, new List <String>()
{
sq.SQL_FROM, c.FR_table
});
query.Add(sq.SQL_WHERE, new List <String>()
{
c.FR_uid
});
query.Add(sq.SQL_COND, new List <String>()
{
newUser.user_Id
});
List <Object[]> newObject = newQuery.SQLSelectQuery(query);
return(newObject);
}
return(null);
}
protected void Page_Load(object sender, EventArgs e)
{
Classes.Auth objAuth = new Classes.Auth();
objAuth.isLoggedIn();
if (IsPostBack)
return;
Classes.User objUser = new Classes.User();
try
{
SqlDataReader userData = objUser.getUser("email", Session["username"].ToString());
if (userData != null)
{
userData.Read();
litEmail.Text = userData["email"].ToString();
txtName.Text = userData["name"].ToString();
txtMobile.Text = userData["mobile"].ToString();
}
}
catch (Exception ex)
{
}
objUser.close();
}
public void Client_UserListChange(object sender, Classes.User e)
{
if (this.InvokeRequired)
{
this.Invoke(new Action(() =>
{
Client_UserListChange(sender, e);
}));
return;
}
if (e != null)
{
Common.Users[e.Id] = e;
}
gbUsers.Controls.Clear();
var users = Common.Users.OrderBy(x => x.Key);
int y = 15;
foreach (var user in users)
{
var lbl = createLabelFor(user.Value, ref y);
lbl.AutoSize = true;
lbl.MaximumSize = new Size(gbUsers.Size.Width - 5, 15);
lbl.TextAlign = ContentAlignment.TopCenter;
gbUsers.Controls.Add(lbl);
lbl.Click += user_click;
}
}
public AdmissionRequestList(Classes.User user)
{
InitializeComponent();
InitListView();
PopulateListView();
currentUser = user;
}
public List <Classes.User> GetUser(String username)
{
var userList = new List <Classes.User>();
query = new Dictionary <string, List <string> >();
query.Add(sq.SQL_PROJECT, new List <string>()
{
sq.SQL_SELECT, c.U_id
});
query.Add(sq.SQL_FROM, new List <string>()
{
sq.SQL_FROM, c.U_table
});
query.Add(sq.SQL_WHERE, new List <string>()
{
c.U_name
});
query.Add(sq.SQL_COND, new List <string>()
{
username
});
List <Object[]> newObject = newQuery.SQLSelectQuery(query);
foreach (var item in newObject)
{
var tempUser = new Classes.User()
{
user_Id = item[0].ToString()
};
userList.Add(tempUser);
}
return(userList);
}
public AdmissionList(Classes.User user)
{
InitializeComponent();
currentUser = user;
InitListView();
PopulateListView();
label1.Text = "Dr. " + currentUser.firstname + " " + currentUser.lastname;
}
public CheckUpList(Classes.User user)
{
InitializeComponent();
InitializeList();
PopulateList();
currentUser = user;
label2.Text = "Dr. " + user.firstname + " " + user.lastname;
}
public static void FillUserTable()
{
Classes.User us1 = new Classes.User(1, 1, "Antonis78", "antonakis78", "*****@*****.**", "Antonis", "Papamixalis", 35);
Classes.User us2 = new Classes.User(2, 2, "Maria47", "maraki47", "*****@*****.**", "Maria", "Antonopoulou", 27);
tableUser[0] = us1;
tableUser[1] = us2;
}
public AdmissionRequest(Classes.Admission admission, Classes.User user)
{
InitializeComponent();
this.admission = admission;
timer1.Start();
Init();
AvailableRoom();
currentUser = user;
}
protected void btnRegister_Click(object sender, EventArgs e)
{
Classes.Validation objValidate = new Classes.Validation();
bool error = false;
litError.Text = "";
if (!objValidate.isValidName(txtName.Text.ToString()))
{
error = true;
litError.Text += "Invalid Name<br>";
}
if (!objValidate.isValidEmail(txtEmail.Text.ToString()))
{
error = true;
litError.Text += "Invalid Email Address<br>";
}
if (!objValidate.isValidPassword(txtPassword.Text.ToString()))
{
error = true;
litError.Text += "Invalid Password<br>";
}
if (txtPassword.Text.ToString() != txtRePassword.Text.ToString())
{
error = true;
litError.Text += "Passwords do not match<br>";
}
if (error)
return;
Classes.User objUser = new Classes.User();
if (objUser.addUser(txtName.Text.ToString(), txtEmail.Text.ToString(), txtPassword.Text.ToString(), null, "Customer"))
{
string activationCode = objUser.getActivationCode(txtEmail.Text.ToString());
string activationLink = "http://" + Request.Url.Authority + "/Account/Activate.aspx?code=" + activationCode + "&email=" + txtEmail.Text.ToString(); ;
string activationMessage = "Hello " + txtName.Text.ToString() + ",<br><br>";
activationMessage += "Please activate your account by clicking on the link:<br><br>";
activationMessage += activationLink;
Classes.Mail objMail = new Classes.Mail(txtEmail.Text.ToString(), "eShopee Account Activation", activationMessage);
litError.Text = "You are successfully registered";
}
else
litError.Text = "Your account could not be registered";
objUser.close();
}
public modUserWindow(Classes.User user_)
{
InitializeComponent();
mod_user = user_;
//display the user data
tb_userName.Text = mod_user.getName();
cb_grade.SelectedIndex = mod_user.getGrade();
}
public Admission(Classes.Admission admission, Classes.User user)
{
InitializeComponent();
currentUser = user;
this.admission = admission;
SettingUp();
InitListView2();
InitListView3();
PopulateList();
PopulateList2();
}
public async Task <ActionResult <Classes.User> > get()
{
var userId = HttpContext.User.Claims.Where(claim => claim.Type == ClaimTypes.NameIdentifier).Select(claim => claim.Value).FirstOrDefault();
Classes.User user = null;
if (userId != null)
{
user = await _userResource.getUser(Convert.ToInt32(userId));
}
return(Ok(user));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
string email = txtEmail.Text.ToString();
string password = txtPassword.Text.ToString();
bool error = false;
litError.Text = "";
Classes.Validation objValidate = new Classes.Validation();
if (!objValidate.isValidEmail(email))
{
error = true;
litError.Text += "Invalid Email Address<br>";
}
if (!objValidate.isValidPassword(password))
{
error = true;
litError.Text += "Invalid Password<br>";
}
if (error)
return;
Classes.Cryptography crypto = new Classes.Cryptography();
password = crypto.genPassHash(password);
Classes.User objUser = new Classes.User();
if (password == objUser.getPassword(email))
{
Session["username"] = email;
Session["loggedIn"] = "true";
Session["role"] = objUser.getRole(email);
Response.Redirect("Dashboard.aspx");
}
else
{
litError.Text = "Invalid Account Login Information Provided";
}
}
catch (Exception ex)
{
litError.Text = "Invalid Account Login Information Provided";
}
}
public async Task <ActionResult <bool> > logout([FromBody] Classes.User user)
{
var guid = HttpContext.User.Claims.Where(claim => claim.Type == ClaimTypes.Authentication).Select(claim => claim.Value).FirstOrDefault();
if (guid != null)
{
await _userResource.deleteToken(user.UserId, guid);
}
await HttpContext.SignOutAsync(
CookieAuthenticationDefaults.AuthenticationScheme);
return(Ok(true));
}
public void PetCreationTest()
{
/* Alivia Houdek */
/* March 22, 2019 */
BusyPet.Classes.Utilities ut = new Classes.Utilities();
// create user
BusyPet.Classes.User user1 = new Classes.User("test1", "test1", ut.ConvertStringToBytes("test1"));
// create pet
BusyPet.Classes.Pet pet1 = new Classes.Pet(user1, "test1", "cat", "male", ut.ConvertStringToDateTime("01/01/2019").ToShortDateString());
Assert.IsNotNull(user1);
Assert.IsNotNull(pet1);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Classes.User objUser = new Classes.User();
Classes.Cryptography objCrypto = new Classes.Cryptography();
Classes.Validation objValidate = new Classes.Validation();
try
{
string email = Session["username"].ToString();
string oldPassword = txtOldPassword.Text.ToString();
string newPassword = txtNewPassword.Text.ToString();
bool error = false;
if (objUser.getPassword(email) != objCrypto.genPassHash(oldPassword))
{
error = true;
litError.Text += "Incorrect Old Password<br>";
}
if (!objValidate.isValidPassword(newPassword))
{
error = true;
litError.Text = "Invalid New Password";
}
if (newPassword != txtConfNewPassword.Text.ToString())
{
error = true;
litError.Text = "Passwords Do Not Match";
}
if (error)
return;
if (objUser.setPassword(email, newPassword))
{
litError.Text = "Password Updated Successfully";
}
}
catch (Exception ex)
{
litError.Text = "Password Could Not Be Updated";
}
objUser.close();
}
public static List <Classes.User> GetAll()
{
List <Classes.User> result = new List <Classes.User>();
string Query = @"Select * FROM `users`";
MySqlCommand cmd = new MySqlCommand(Query, connexion);
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Classes.User user = new Classes.User(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
result.Add(user);
}
}
cmd = null;
return(result);
}
private void Load()
{
this.Items = new Dictionary <string, Classes.User>();
XmlNodeList xmlNodes = this.Document.DocumentElement.SelectNodes("User");
User user;
foreach (XmlNode xmlNode in xmlNodes)
{
user = new Classes.User();
user.Id = Guid.Parse(xmlNode.Attributes["IdUser"].Value);
user.Client = xmlNode.Attributes["Client"].Value;
user.AmazonId = xmlNode.Attributes["AmazonId"].Value;
this.Items.Add(user.AmazonId, user);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Classes.User user = Classes.User.getUsuarioByLogin(txtEmail.Text, txtPassword.Text);
if (user == null)
{
trAlertTr.Attributes.CssStyle.Value = "trVisible";
lblLoginError.Text = "The e-mail and/or password entered is invalid. Please try again";
txtEmail.BorderColor = System.Drawing.Color.Red;
txtPassword.BorderColor = System.Drawing.Color.Red;
}
else
{
Session["User"] = user;
trAlertTr.Attributes.CssStyle.Value = "trInvisible";
txtEmail.BorderColor = System.Drawing.Color.Black;
txtPassword.BorderColor = System.Drawing.Color.Black;
Response.Redirect("CustomerListPage.aspx");
}
}
public void PrivateMessage(Classes.User from, User to, string message)
{
var msg = new Message();
msg.Author = Menu.Server.SERVERUSER;
msg.Colour = System.Drawing.Color.Gold;
msg.Content = $"[PM] {from.DisplayName}({from.Id}) -> me: {message}";
msg.Id = Common.IterateMessageId();
SendTo(to, new Packet(PacketId.NewMessage, msg.ToJson()));
msg.Colour = System.Drawing.Color.Gray;
msg.Id = Common.IterateMessageId();
msg.Content = $"[PM] me -> {to.DisplayName}({to.Id}): {message}";
SendTo(from, new Packet(PacketId.NewMessage, msg.ToJson()));
msg.Id = Common.IterateMessageId();
msg.Content = $"[PM] {from.DisplayName}({from.Id}) -> {to.UserName}({to.Id}): {message}";
_internalServerMessage(msg);
}
public static Classes.User GetOne(string Mail)
{
string Query = @"SELECT * FROM `users` WHERE `email` = " + Mail;
MySqlCommand cmd = new MySqlCommand(Query, connexion);
try
{
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
rdr.Read();
Classes.User user = new Classes.User(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
cmd = null;
return(user);
}
}
catch (MySqlException e)
{
return(new Classes.User(e.Message));
}
}
public Classes.User GetUserDetails(String userID)
{
query = new Dictionary <string, List <string> >();
query.Add(sq.SQL_PROJECT, new List <string>()
{
sq.SQL_SELECT, c.U_id, c.U_name, c.U_avgStars, c.U_fans, c.U_yelpingSince, c.U_funny,
c.U_cool, c.U_useful, c.U_latitude, c.U_longitude
});
query.Add(sq.SQL_FROM, new List <string>()
{
sq.SQL_FROM, c.U_table
});
query.Add(sq.SQL_WHERE, new List <string>()
{
c.U_id
});
query.Add(sq.SQL_COND, new List <string>()
{
userID
});
List <Object[]> newObject = newQuery.SQLSelectQuery(query);
foreach (Object[] users in newObject)
{
Classes.User tempUser = new Classes.User()
{
user_Id = users[0].ToString(),
username = users[1].ToString(),
average_stars = Double.Parse(users[2].ToString()),
fans = Int32.Parse(users[3].ToString()),
yelping_since = users[4].ToString(),
funny = Int32.Parse(users[5].ToString()),
cool = Int32.Parse(users[6].ToString()),
useful = Int32.Parse(users[7].ToString()),
user_latitude = Double.Parse(users[8].ToString()),
user_longitude = Double.Parse(users[9].ToString())
};
return(tempUser);
}
return(null);
}
public ActionResult Index(ProfileViewModel profileInfo)
{
//if (ModelState.IsValid)
//{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var newUserInfo = new Classes.User();
var oldUserInfo = (from u in dbc.Users where u.Email == profileInfo.Email select u).ToList().FirstOrDefault();
if (oldUserInfo != null)
{
dbc.Users.DeleteOnSubmit(oldUserInfo);
dbc.SubmitChanges();
//Currently constant fields:
newUserInfo.ID = oldUserInfo.ID;
newUserInfo.UserName = oldUserInfo.UserName;
newUserInfo.Password = oldUserInfo.Password;
//Changable fields:
newUserInfo.FirstName = profileInfo.FirstName;
newUserInfo.LastName = profileInfo.LastName;
newUserInfo.Phone = profileInfo.Phone;
newUserInfo.Address = profileInfo.Address;
newUserInfo.Email = profileInfo.Email;
dbc.Users.InsertOnSubmit(newUserInfo);
dbc.SubmitChanges();
ProfileViewModel newProfile = new ProfileViewModel();
newProfile.UserName = newUserInfo.UserName ?? "";
newProfile.FirstName = newUserInfo.FirstName ?? "";
newProfile.LastName = newUserInfo.LastName ?? "";
newProfile.Email = newUserInfo.Email ?? "";
newProfile.Phone = newUserInfo.Phone ?? "";
newProfile.Address = newUserInfo.Address ?? "";
return View(newProfile);
}
}
//}
return View(profileInfo);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Classes.User objUser = new Classes.User();
try
{
string email = Session["username"].ToString();
string name = txtName.Text.ToString();
string mobile = txtMobile.Text.ToString();
Classes.Validation objValidate = new Classes.Validation();
bool error = false;
litError.Text = "";
if (!objValidate.isValidName(name))
{
error = true;
litError.Text = "Invalid Name";
}
if (error)
return;
if (objUser.setUser(name, email, mobile))
{
litError.Text = "Account Updated Successfully";
}
}
catch (Exception ex)
{
litError.Text = "Account Could Not be Updated";
}
objUser.close();
}
public static void setTenant(Classes.User tenant, Classes.PropertyDetails pd, MainUI m)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var info = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) &&
p.Detailed_Address == pd.DetailedAddress && p.Additional_Comments == pd.AdditionalComment && p.RentRangeId == int.Parse(pd.RentRange)
select p).SingleOrDefault();
var userid = (from q in cntx.Users
where q.UserName == tenant.UserName
select q).SingleOrDefault();
Tenant t = new Tenant();
t.UserId = userid.UserId;
t.PropertyId = info.PropertyId;
cntx.Tenants.InsertOnSubmit(t);
cntx.SubmitChanges();
m.GetData();
}
public Boolean Post([FromBody] Classes.User user)
{
if (user.Email != null && user.Password != null)
{
user.Email = user.Email.ToLower();
checkarr.checkarrContext registerDBContext = new checkarr.checkarrContext();
checkarr.UserLog UserRegister = registerDBContext.UserLog.FirstOrDefault(i => i.UserEmaill == user.Email);
if (UserRegister != null)
{
// To be executed when user exists in the DB
System.Diagnostics.Debug.Print("> User Exists");
return(false);
}
else
{
string temp_email;
// To be executed when user doesn't exist in the DB
UserRegister = new checkarr.UserLog();
UserRegister.UserFullname = user.Fullname;
UserRegister.UserEmaill = user.Email;
temp_email = user.Email;
UserRegister.UserPassword = user.Password;
UserRegister.UserSex = user.Gender;
UserRegister.UserReg = DateTime.UtcNow;
UserRegister.Activated = "F";
UserRegister.Disabled = "F";
// AuthRepository _authRepository = new AuthRepository(registerDBContext);
/* have to make this await */
// _authRepository.Register(UserRegister, user.Password);
//Adding user to the register context and saving that context
registerDBContext.UserLog.Add(UserRegister);
registerDBContext.SaveChanges();
Classes.Mailer currentMailer = new Classes.Mailer();
currentMailer.sendWelcomeMail(user.Email);
/*
* int newUserID;
* //
* // Id of last user
* UserRegister = registerDBContext.UserLog.Last();
* if(temp_email == UserRegister.UserEmaill)
* newUserID = UserRegister.IduserLog;
* else
* {
* UserRegister = registerDBContext.UserLog.FirstOrDefault(i => i.UserEmaill == temp_email);
* newUserID = UserRegister.IduserLog;
* }
* Classes.CodeGenerator codeGenerator = new Classes.CodeGenerator();
* String activationCode = codeGenerator.ActivationCodeGenerator();
*
* // saving in confirmation code table
* checkarr.Confirmationcode confirmationCodeModel = new checkarr.Confirmationcode();
* confirmationCodeModel.ConfirmationCode = activationCode;
* confirmationCodeModel.ConfirmationType = "ACTIVATION_CODE";
* confirmationCodeModel.GeneratedOn = DateTime.UtcNow;
* confirmationCodeModel.ExpiryTime = DateTime.UtcNow.AddDays(1);
* confirmationCodeModel.Used = "F";
* confirmationCodeModel.UserId = newUserID;// have to update user id
*
* registerDBContext.Confirmationcode.Add(confirmationCodeModel);
* registerDBContext.SaveChanges();
*
*
* Classes.Token tokenGenerator = new Classes.Token();
* JwtSecurityToken activationToken = tokenGenerator.GenerateActivationToken(newUserID);
*
*
* // sending activation mail
* Classes.Mailer currentMailer = new Classes.Mailer();
* currentMailer.sendActivationMail(user.Email, new JwtSecurityTokenHandler().WriteToken(activationToken), activationCode);
*/
//System.Diagnostics.Debug.Print("===========================\n");
//System.Diagnostics.Debug.Print("Register POST\n");
//System.Diagnostics.Debug.Print("===========================\n");
//System.Diagnostics.Debug.Print("Fullname: " + user.Fullname + "\n");
//System.Diagnostics.Debug.Print("Email: " + user.Email + "\n");
//System.Diagnostics.Debug.Print("Password: "******"\n");
//System.Diagnostics.Debug.Print("Gender: " + user.Gender + "\n");
//System.Diagnostics.Debug.Print("===========================\n");
return(true);
}
// return false;
}
else
{
return(false);
}
}
public void SetCurrentUser(Classes.User user)
{
newUser = user;
}
public TestArticles(MainWindow mainWindow, Classes.User user, Classes.Test test)
{
this.mainWindow = mainWindow;
this.user = user;
this.test = test;
InitializeComponent();
txbNameTest.Text = test.Name.ToString();
txbNameTest.TextWrapping = TextWrapping.Wrap;
string testArticles = "TEST_ARTICLES_TESTS";
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
SqlCommand testArticlesCommand = new SqlCommand(testArticles, sqlConnection);
testArticlesCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter testIdParameter = new SqlParameter
{
ParameterName = "@test_Id",
Value = test.idTest
};
testArticlesCommand.Parameters.Add(testIdParameter);
SqlDataReader readerQuestion = testArticlesCommand.ExecuteReader();
if (readerQuestion.HasRows)
{
while (readerQuestion.Read())
{
Classes.CreateTests createTest = new Classes.CreateTests();
createTest.NameTest = readerQuestion.GetValue(0);
createTest.IdQuestion = readerQuestion.GetValue(1);
createTest.NumberQuestion = readerQuestion.GetValue(2);
createTest.Question = readerQuestion.GetValue(3);
createTests.Add(createTest);
}
}
readerQuestion.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
for (int i = 0; i < createTests.Count; i++)
{
Grid grid = new Grid();
grid.Height = 170;
TextBlock txbNumberQuestion = new TextBlock();
//txbNumberQuestion.Text = createTests[i].NumberQuestion.ToString() + ".";
txbNumberQuestion.Text = (i + 1).ToString() + ".";
txbNumberQuestion.FontSize = 30;
txbNumberQuestion.Margin = new Thickness(10, 20, 10, 20);
grid.Children.Add(txbNumberQuestion);
Border border = new Border();
border.Height = 90;
border.Margin = new Thickness(60, 20, 60, 20);
border.VerticalAlignment = VerticalAlignment.Top;
border.CornerRadius = new CornerRadius(15);
border.BorderThickness = new Thickness(1);
border.BorderBrush = new SolidColorBrush(Colors.Black);
TextBlock txbQuestion = new TextBlock();
txbQuestion.Text = createTests[i].Question.ToString();
txbQuestion.Margin = new Thickness(5, 0, 0, 0);
txbQuestion.FontSize = 30;
txbQuestion.TextWrapping = TextWrapping.Wrap;
border.Child = txbQuestion;
StackPanel stackPanel = new StackPanel();
stackPanel.Orientation = Orientation.Horizontal;
stackPanel.Margin = new Thickness(60, 130, 0, 0);
//получаем ответы по вопросу
string articlesAnswer = "TEST_ARTICLES_ANSWERS ";
List <string> answers = new List <string>();
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
SqlCommand articlesAnswerCommand = new SqlCommand(articlesAnswer, sqlConnection);
articlesAnswerCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter qustionParameter = new SqlParameter
{
ParameterName = "@question",
Value = createTests[i].Question
};
articlesAnswerCommand.Parameters.Add(qustionParameter);
SqlDataReader readerAnswer = articlesAnswerCommand.ExecuteReader();
if (readerAnswer.HasRows)
{
while (readerAnswer.Read())
{
answers.Add(readerAnswer.GetValue(0).ToString());
}
}
readerAnswer.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
answers = answers.OrderBy(a => Guid.NewGuid()).ToList();
for (int j = 0; j < answers.Count; j++)
{
RadioButton radioButton1 = new RadioButton();
radioButton1.Content = answers[j].ToString();
radioButton1.FontSize = 18;
radioButton1.Margin = new Thickness(20, 0, 0, 0);
radioButton1.Padding = new Thickness(10, -3, 0, 0);
stackPanel.Children.Add(radioButton1);
}
grid.Children.Add(border);
grid.Children.Add(stackPanel);
stkPQuestion.Children.Add(grid);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ActionResult Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var userInfo = (from u in dbc.Users where u.Email == model.Email select u).ToList().FirstOrDefault();
if (userInfo == null)
{
var user = new Classes.User()
{
UserName = model.UserName,
FirstName = model.FirstName,
LastName = model.LastName,
Phone = model.Phone,
Email = model.Email,
Password = model.Password
};
dbc.Users.InsertOnSubmit(user);
dbc.SubmitChanges();
FormsAuthentication.SetAuthCookie(model.Email, false);
return RedirectToAction("Index", "Home");
}
else
{
ModelState.AddModelError("", "Email address already in use.");
}
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
