protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
using (MD5 md5hash = MD5.Create())
{
string hashPass = HashMD5(md5hash, RegisterUser.Password.Trim()); // haslo zahashowane
heartbaseEntities db = new heartbaseEntities(); // zapis parametrow z formularza
// string name = Request.Form[6];
Userss us = new Userss
{
Username = RegisterUser.UserName.Trim(),
Password = hashPass,
Email = RegisterUser.Email.Trim(),
Name = Request.Form[6].ToString(), //RegisterUser.Name.Trim(),
Surname = Request.Form[7].ToString()
//Name = "name",
//Surname = "surname"
};
db.Userss.Add(us);
db.SaveChanges();
/*
* int ID = 0;
* string connStr = ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString;
* using (SqlConnection conn = new SqlConnection(connStr))
* {
* using (SqlCommand cmd = new SqlCommand())
* {
* //using (SqlDataAdapter sda = new SqlDataAdapter())
* //{
* // cmd.CommandType = CommandType.StoredProcedure;
* // cmd.Parameters.AddWithValue("@Username", RegisterUser.UserName.Trim());
* // cmd.Parameters.AddWithValue("@Password", hashPass);
* // cmd.Parameters.AddWithValue("@Email", RegisterUser.Email.Trim());
* // cmd.Connection = conn;
* // conn.Open();
* // ID = Convert.ToInt32(cmd.ExecuteScalar());
* // conn.Close();
* //}
*
* cmd.CommandText = "select * from Userss";
* cmd.Connection = conn;
* cmd.CommandType = CommandType.TableDirect
*
*
*
* }
* SendActivationEmail(ID);
* }
*/
}
}
protected void Accept_Click(object sender, EventArgs e)
{
try
{
string name = Request.Form["Name"];
string surname = Request.Form["Surname"];
int sex = Convert.ToInt32(Request.Form["Sex"]);
double age = Convert.ToDouble(Request.Form["Age"]);
string pain = Request.Form["Pain"];
int painC = 0;
if (pain != null)
{
string[] split = pain.Split(',');
for (int i = 0; i < split.Length; i++)
{
int variable = Convert.ToInt32(split[i]);
painC += variable;
}
}
double bPress = Convert.ToDouble(Request.Form["BPress"]);
double chol = Convert.ToDouble(Request.Form["Cholesterol"]);
int smoker = Convert.ToInt32(Request.Form["Smoker"]);
double sWeek = 0;
//double sYear = 0;
if (smoker == 0)
{
sWeek = Convert.ToDouble(Request.Form["CigPerWeek"]);
}
double sugar = Convert.ToDouble(Request.Form["Sugar"]);
int famSugar = Convert.ToInt32(Request.Form["SugarFam"]);
int rEkg = Convert.ToInt32(Request.Form["restEKG"]);
//double mHR = Convert.ToDouble(Request.Form["MaxHR"]);
double rHR = Convert.ToDouble(Request.Form["RestHR"]);
double fat = Convert.ToDouble(Request.Form["Fat"]);
int kidney = Convert.ToInt32(Request.Form["Kidney"]);
//RiskCounter rc = new RiskCounter();
//double[,] result = rc.fuzzyRisk(age, bPress, chol, sWeek, sugar, rHR, fat);
// List<int> addedRisk = rc.addedRisk(age, sex, painC, famSugar, rEkg, kidney);
double[,] result = new double[2, 2]; // TM TEST!!!
result[1, 1] = 50; // TM TEST!!!
List <int> addedRisk = new List <int>();
addedRisk.Add(1);
string im = name;
string nz = surname;
Context.Items["result"] = result;
Context.Items["addedRisk"] = addedRisk;
Context.Items["name"] = im;
Context.Items["surname"] = nz;
heartbaseEntities db = new heartbaseEntities(); // przygotowanie do zapisu do bazy do tabeli Results
Results r = new Results // parsujemy dane z formularza
{
Name = name,
Surname = surname,
Sex = sex,
Age = age,
Pain = pain,
PainC = painC,
BPress = bPress,
Cholesterol = chol,
Smoker = smoker,
CigPerWeek = sWeek,
Sugar = sugar,
SugarFam = famSugar,
restEKG = rEkg,
RestHR = rHR,
Fat = fat,
Kidney = kidney,
result = result[0, 0]
};
db.Results.Add(r); // dodajemy do bazy
db.SaveChanges();
// zapis wyniku do bazy do tabeli Users_results
string login = User.Identity.Name; // wyciaganie aktualnie zalogowanego uzytkownika
var userss = db.Userss.Where(x => x.Username == login); // to jest login! potrzebujemy id
Userss[] user = userss.ToArray();
if (user.Length > 0) // wiec jesli znajdziemy jakiegos uzytkownika
{
int idUser = user[0].Id; // to pobieramy jego id
var maxx = db.Results.ToList().Last(); // i pobieramy id wlasnie dodanego rekordu result
int idRes = maxx.Id;
Users_results ur = new Users_results // wiazemy te dwa id
{
Id_result = idRes,
Id_user = idUser
};
db.Users_results.Add(ur); // dodajemy i zapisujemy do bazy
db.SaveChanges();
}
Server.Transfer("Result.aspx", true);
}
catch (NullReferenceException ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + "Uzupełnij wszystkie pola!" + "');", true);
}
catch (SystemException ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + ex.Message + "');", true);
}
catch (MatlabProcessingException ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + "Błąd przetwarzania danych (brak połączenia z serwerem?)" + "');", true);
}
}
