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); } }