protected void Autofill_Click(object sender, EventArgs e)
{
if (User.Identity.IsAuthenticated)
{
heartbaseEntities db = new heartbaseEntities(); // przygotowanie do zapisu do bazy do tabeli 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
// TODO zabezpieczyc przed brakiem elementow w Users_Results
var maxx = db.Users_results.Where(x => x.Id_user == idUser).ToList().Last();
var res = db.Results.Where(x => x.Id == maxx.Id_result).ToList().Last(); // i pobieramy id wlasnie dodanego rekordu result
//assignFieldValue("Name", res.Name);
//assignFieldValue("Surname", res.Surname);
//assignFieldValue("Sex", res.Sex.ToString());
//assignFieldValue("Age", res.Age.ToString());
//assignFieldValue("Pain", res.Pain.ToString());
//assignFieldValue("BPress", res.BPress.ToString());
//assignFieldValue("Cholesterol", res.Cholesterol.ToString());
//assignFieldValue("Smoker", res.Smoker.ToString());
//assignFieldValue("CigPerWeek", res.CigPerWeek.ToString());
//assignFieldValue("Sugar", res.Sugar.ToString());
//assignFieldValue("SugarFam", res.SugarFam.ToString());
//assignFieldValue("restEKG", res.restEKG.ToString());
//assignFieldValue("RestHR", res.RestHR.ToString());
//assignFieldValue("Fat", res.Fat.ToString());
//assignFieldValue("Kidney", res.Kidney.ToString());
//fillValues(name, surname, sex, age, pain, bpress, chol, smoker, cigperweek, sugar, sugarfam, restekg, resthr, fat, kidney)
ClientScript.RegisterStartupScript(GetType(), "hwa", "fillValues("
+ "\"" + res.Name + "\", "
+ "\"" + res.Surname + "\", "
+ "\"" + res.Sex + "\", "
+ "\"" + res.Age + "\", "
+ "\"" + res.Pain + "\", "
+ "\"" + res.BPress + "\", "
+ "\"" + res.Cholesterol + "\", "
+ "\"" + res.Smoker + "\", "
+ "\"" + res.CigPerWeek + "\", "
+ "\"" + res.Sugar + "\", "
+ "\"" + res.SugarFam + "\", "
+ "\"" + res.restEKG + "\", "
+ "\"" + res.RestHR + "\", "
+ "\"" + res.Fat + "\", "
+ "\"" + res.Kidney + "\", "
+ ");", true);
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "hwa", "fill();", true);
}
}
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 Autofill_Click(object sender, EventArgs e)
{
if (User.Identity.IsAuthenticated)
{
heartbaseEntities db = new heartbaseEntities(); // przygotowanie do zapisu do bazy do tabeli 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
// TODO zabezpieczyc przed brakiem elementow w Users_Results
if (db.Users_results.Where(x => x.Id_user == idUser).Any())
{
var maxx = db.Users_results.Where(x => x.Id_user == idUser).ToList().Last();
var res = db.Results.Where(x => x.Id == maxx.Id_result).ToList().Last(); // i pobieramy id wlasnie dodanego rekordu result
ClientScript.RegisterStartupScript(GetType(), "hwa", "fillValues("
+ "\"" + res.Name + "\", "
+ "\"" + res.Surname + "\", "
+ "\"" + res.Sex + "\", "
+ "\"" + res.Age + "\", "
+ "\"" + res.Pain + "\", "
+ "\"" + res.BPress + "\", "
+ "\"" + res.Cholesterol + "\", "
+ "\"" + res.Smoker + "\", "
+ "\"" + res.CigPerWeek + "\", "
+ "\"" + res.Sugar + "\", "
+ "\"" + res.SugarFam + "\", "
+ "\"" + res.restEKG + "\", "
+ "\"" + res.RestHR + "\", "
+ "\"" + res.Fat + "\", "
+ "\"" + res.Kidney + "\", "
+ ");", true);
}
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "hwa", "fill();", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (User.Identity.IsAuthenticated)
{
heartbaseEntities db = new heartbaseEntities(); // przygotowanie do zapisu do bazy do tabeli 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
ClientScript.RegisterStartupScript(GetType(), "hwa", "fillValues("
+ "\"" + user[0].Name + "\", "
+ "\"" + user[0].Surname + "\", "
+ ");", true);
}
}
}
protected void LoginButton_Click(object sender, EventArgs e)
{
using (MD5 md5Hash = MD5.Create())
{
string hashPass = HashMD5(md5Hash, loginForm1.Password);
heartbaseEntities db = new heartbaseEntities();
string Username = loginForm1.UserName.Trim();
string Password = hashPass;
var userss = db.Userss.Where(x => x.Username == Username);
Userss[] user = userss.ToArray();
if (user.Length > 0)
{
if (user[0].Password == Password)
{
FormsAuthentication.RedirectFromLoginPage(loginForm1.UserName, loginForm1.RememberMeSet);
}
else
{
loginForm1.FailureText = "Username and/or password is incorrect.";
}
}
else
{
loginForm1.FailureText = "Username and/or password is incorrect.";
}
/*
* int ID = 0;
* string constr = ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString;
* using (SqlConnection con = new SqlConnection(constr))
* {
* using (SqlCommand cmd = new SqlCommand("Validate_User"))
* {
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.Parameters.AddWithValue("@Username", loginForm1.UserName);
* cmd.Parameters.AddWithValue("@Password", hashPass);
* cmd.Connection = con;
* con.Open();
* ID = Convert.ToInt32(cmd.ExecuteScalar());
* con.Close();
* }
* switch (ID)
* {
* case -1:
* loginForm1.FailureText = "Username and/or password is incorrect.";
* break;
* case -2:
* loginForm1.FailureText = "Account has not been activated.";
* break;
* default:
* FormsAuthentication.RedirectFromLoginPage(loginForm1.UserName, loginForm1.RememberMeSet);
* break;
* }
* }
*/
}
}
protected void Page_Load()
{
heartbaseEntities db = new heartbaseEntities(); // przygotowanie do zapisu do bazy do tabeli 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();
List <Users_results> ur = null;
List <Results> r = new List <Results>();
if (user.Length > 0) // wiec jesli znajdziemy jakiegos uzytkownika
{
int idUser = user[0].Id; // to pobieramy jego id
var resul = db.Users_results.Where(x => x.Id_user == idUser);
foreach (Users_results userresult in resul.ToList())
{
var resul2 = db.Results.Where(x => x.Id == userresult.Id_result);
Results[] result = resul2.ToArray();
if (result.Length > 0)
{
r.Add(result[0]);
}
}
}
GridView1.DataSource = r;
GridView1.DataBind();
//if (!IsPostBack )
//{
// // Determine the sections to render
// var hasLocalPassword = User.Identity.IsAuthenticated;
// // setPassword.Visible = !hasLocalPassword;
// changePassword.Visible = hasLocalPassword;
// CanRemoveExternalLogins = hasLocalPassword;
// // Render success message
// var message = Request.QueryString["m"];
// if (message != null)
// {
// // Strip the query string from action
// Form.Action = ResolveUrl("~/Account/Manage");
// SuccessMessage =
// message == "ChangePwdSuccess" ? "Your password has been changed."
// : message == "SetPwdSuccess" ? "Your password has been set."
// : message == "RemoveLoginSuccess" ? "The external login was removed."
// : String.Empty;
// successMessage.Visible = !String.IsNullOrEmpty(SuccessMessage);
// }
//}
}
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);
}
}
