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