public void Page_Load(object sender, EventArgs e) { ScanPerson scnPerson = (ScanPerson)Session["session"]; LoggIn lg = new LoggIn(); ChartDetails chrd = new ChartDetails(); Dictionary <TimeSpan, double> DictionaryPromilesAndHours = new Dictionary <TimeSpan, double>(); DictionaryPromilesAndHours = scnPerson.alcoReducingInTime(scnPerson.DrinkStartVal, scnPerson.DrinkTimeValue, scnPerson.MaxAlcoCOncentrationVal); foreach (KeyValuePair <TimeSpan, double> item in DictionaryPromilesAndHours) { PromilesInBloodCrt.Series[0].Points.AddXY(item.Key.ToString(), Math.Round(item.Value, 2)); } string nicki = (string)Session["Nick"]; if (Session["correctLogin"] != null) { lg.RightUser = (bool)Session["correctLogin"]; } if (lg.RightUser == true) { toSql(scnPerson, chrd, DictionaryPromilesAndHours); toRaport(scnPerson, chrd, DictionaryPromilesAndHours, nicki); Session["session"] = scnPerson; Session["correctLogin"] = null; _imie.ToString(); } if (lg.RightUser == false) { toRaport(scnPerson, chrd, DictionaryPromilesAndHours, nicki); } if (uzytkownikLbl.Text != null) { uzytkownikLbl.Text = _imie.ToString(); } }
protected void Button1_Click(object sender, EventArgs e) { ScanPerson scnPerson = new ScanPerson(); LoggIn logg = new LoggIn(); try { namePerson = nameTxb.Text; emailPerson = emailTxb.Text; passPerson = passTxb.Text; confirmPass = confirmPassTxb.Text; string wrongInfo = wrongInfoEmailLbl.Text; correctEmail = isValidEmail(emailPerson); if (!correctEmail) { wrongInfoEmailLbl.Text = "Podaj poprawny mail"; } else { PersonDataRegistration prsnDataReg = new PersonDataRegistration(namePerson, emailPerson, passPerson, confirmPass); prsnDataReg.SetUnicqlyValue(namePerson, emailPerson, passPerson, confirmPass); logg.logUser(namePerson, emailPerson, passPerson); prsnDataReg.lookAtName(CheckIsNickIn); } } catch (Exception exception) { wrongInfoLbl.Text = "Wystąpił nieoczekiwany błąd" + exception; // wysylaj maila } EmailOnDatabase(emailPerson); }
public void SetUnicqlyValue(string namePerson, string emailPerson, string passPerson, string confirmPass) { string updateData = "Insert Into AlcPrsnTable" + " (namePerson,emailPerson,passPerson,confirmPass) Values(@namePerson,@emailPerson,@passPerson,@confirmPass)"; SqlCommand cmd = new SqlCommand(); using (var con = new SqlConnection()) { try { con.ConnectionString = "Data Source=JAC-KOMPUTER\\SQLEXPRESS;Initial Catalog=AlcoPersonalDataSql;Integrated Security=True"; cmd.CommandText = updateData; con.Open(); ScanPerson scnPrs = new ScanPerson(); cmd.CommandText = "SELECT * FROM [AlcPrsnTable]"; cmd.Connection = con; } catch (SqlException se) { wrongInfoLbl.Text = "Błąd dostępu do Bazy Danych" + se.StackTrace; } SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { if (rd[1].ToString() == NamePerson) { nameIsOnStorge = true; con.Close(); break; } // powtarzajacy sie kod i = rd.GetInt32(0); Session["imieUsera"] = i + 1; } rd.Close(); if (nameIsOnStorge == true) { con.Close(); } if (nameIsOnStorge == false) { cmd.CommandText = updateData; Session["Nick"] = namePerson; cmd.Parameters.AddWithValue("@namePerson", namePerson); cmd.Parameters.AddWithValue("@emailPerson", emailPerson); cmd.Parameters.AddWithValue("@passPerson", passPerson); cmd.Parameters.AddWithValue("@confirmPass", confirmPass); cmd.ExecuteNonQuery(); } } }
public void toSql(ScanPerson scPerson, ChartDetails chrd, Dictionary <TimeSpan, double> oo) { _imie = (int)Session["imieUsera"]; string hours, maxProm; hours = Convert.ToString(chrd.ten(oo) / 2 - 2); maxProm = Convert.ToString(chrd.tamten(oo)); string weight = Convert.ToString(scPerson.WeightValue); string minilitres = Convert.ToString(scPerson.MinilitresOfDrinkedAlcValue); string testDate = dataTodayLbl.Text = DateTime.Now.ToString(); WhichGender(scPerson); UpdateAlcoDataBase(weight, hours, minilitres, maxProm, testDate, _imie); }
protected void countPromiles_Click(object sender, EventArgs e) { try { if ( !double.TryParse(genderRBtn.Text, out genderValueToReducaAlcoholPerHour) || !double.TryParse(weightPersonTbx.Text, out weightValue) || weightValue <= 0 || // && weightPersonTbx.MaxLength.Equals(1) || !double.TryParse(alcoholAmountsTbx.Text, out amountsOfDrinkedAlcValue) || amountsOfDrinkedAlcValue <= 0 || !int.TryParse(drinkStartDdl.Text, out drinkStartVal) || drinkStartVal <= 0 || !int.TryParse(drinkTimeTxb.Text, out drinkTimeValue) || drinkTimeValue <= 0 || !double.TryParse(alcoholAmountsTbx.Text, out amountsOfDrinkedAlcValue) || amountsOfDrinkedAlcValue <= 0 || !double.TryParse(alcoholVoltageTxb.Text, out alcoVoltageValToReducaAlcoholPerHour) || alcoVoltageValToReducaAlcoholPerHour <= 0 || alcoVoltageValToReducaAlcoholPerHour > 96) { if (alcoVoltageValToReducaAlcoholPerHour > 96) { invalidDataLbl.Text = "W naszej bazie nie istnieje alkohol trunek mocniejszy niż 96% alk. Wpisz innną wartość."; alcoholVoltageTxb.BorderColor = System.Drawing.Color.Red; } else { invalidDataLbl.Text = "błąd podaj opdowiednia wartosc"; } } else { if (genderValueToReducaAlcoholPerHour == 0) { genderValueToReducaAlcoholPerHour = 0.6; } else { genderValueToReducaAlcoholPerHour = 0.7; } alcoVoltageValToReducaAlcoholPerHour = alcoVoltageValToReducaAlcoholPerHour * 0.01; double maxAlcoCOncentrationVal; maxAlcoCOncentrationVal = CalculateAlcoVoltage(genderValueToReducaAlcoholPerHour, weightValue //@ , amountsOfDrinkedAlcValue, alcoVoltageValToReducaAlcoholPerHour); ScanPerson scnPerson = new ScanPerson(genderValueToReducaAlcoholPerHour, weightValue , amountsOfDrinkedAlcValue, alcoVoltageValToReducaAlcoholPerHour, drinkStartVal, drinkTimeValue, maxAlcoCOncentrationVal); Dictionary <TimeSpan, double> DictionaryAlkInTime = new Dictionary <TimeSpan, double>(); Session["session"] = scnPerson; Response.Redirect("AlcoRaportChart.aspx"); } } catch (Exception ex) { invalidDataLbl.Text = ex.StackTrace; } }
public void toRaport(ScanPerson scPerson, ChartDetails chrd, Dictionary <TimeSpan, double> oo, string nick) { rprtWeightLbl.Text = Convert.ToString(scPerson.WeightValue); rprtAmountLbl.Text = Convert.ToString(scPerson.MinilitresOfDrinkedAlcValue); rprtVoltageLbl.Text = Convert.ToString(scPerson.AlcoVoltageVal * 100); WhichGender(scPerson); rprtDrunkTimeLbl.Text = Convert.ToString(chrd.ten(oo) / 2 - 2); rprtDataLbl.Text = dataTodayLbl.Text = DateTime.Now.ToString(); if (Session["Nick"] != null) { rprtNameLbl.Text = nick; } Session["Nick"] = null; }
public void userAccepted(bool userOk) { ScanPerson scPerson = new ScanPerson(); if (userOk == false) { wrongNameEmailLogLbl.Text = "Niepoprawny login lub haslo"; } else { AlcoRaportChart alcrptCha = new AlcoRaportChart(); _rightUser = true; Session["correctLogin"] = _rightUser; Response.Redirect("USerPanelForm.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { string nicki = (string)Session["Nick"]; ScanPerson scnPerson = (ScanPerson)Session["session"]; if (Session["correctLogin"] != null) { logInInfoLbl.Text = "WITAJ " + nicki + " !!!"; } else if (Session["correctLogin"] != null) { logInInfoLbl.Text = "Zaloguj się"; } } catch (Exception exception) { ScriptManager.RegisterStartupScript(this, GetType(), "error", "alert('Wystąpił błąd podczas ładowania strony');", true); } }
protected void enterUserBtn_Click(object sender, EventArgs e) { ScanPerson scnPerson = new ScanPerson(); try { string nameUser = nameUserTxb.Text; string passUser = passUserTxb.Text; string emailUser = emailUserTxb.Text; Session["imie"] = nameUser; logUser(nameUser, emailUser, passUser); UserOnStaff(userAccepted); nameUserTxb.MaxLength.Equals(10); passUserTxb.MaxLength.Equals(10); emailUserTxb.MaxLength.Equals(10); Session["session"] = scnPerson; } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "error", "alert('Wystąpił błąd podczas ładowania strony');", true); } }
private string WhichGender(ScanPerson scnPrsn) { return(scnPrsn.GenderValue > 0.6 ? rprtGenderLbl.Text = "mężczyzna" : rprtGenderLbl.Text = "kobieta"); }
protected void Page_Load(object sender, EventArgs e) { ScanPerson scnPerson = (ScanPerson)Session["session"]; }