Ejemplo n.º 1
0
        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);
                 * }
                 */
            }
        }
Ejemplo n.º 2
0
        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);
            }
        }