//public string username //{ // get // { // return username; // } // set // { // if (username != value) // { // PropertyChanged.Invoke(this, new PropertyChangedEventArgs("Username")); // username = value; // } // } //} public UserName_model Return_info(string username) { UserName_model user = new UserName_model(); string sql = "SELECT ID_User,Username,Weight,Height,Sex,Age,ActivityLevel,BMI,BMR FROM Users WHERE Username = @user"; var command = new SqlCommand(sql, DB.Connection()); command.Parameters.AddWithValue("@user", username); SqlDataReader reader = command.ExecuteReader(); DB.Connection_Close(DB.Connection()); while (reader.Read()) { user.ID_User = reader.GetInt32(0); user.Username = reader.GetString(1); user.Weight = reader.GetDouble(2); user.Height = reader.GetDouble(3); user._sex = reader.GetString(4); user.Age = reader.GetByte(5); user.ActivityLevel = reader.GetString(6); user.BMI = reader.GetDecimal(7); user.BMR = reader.GetDecimal(8); } Sex = (user._sex == "Man") ? EnumSex.Man : EnumSex.Woman; return(user); }
public UserWindow() { InitializeComponent(); username.Content = Global_Methods.username; user_model = user_model.Return_info(Global_Methods.username); id_diary = queries.ReturnUserIDdiary(user_model.ID_User); CalculateStartAndEndDate(); RefreshChart(); }
public Add_Product() { InitializeComponent(); user_model = user_model.Return_info(Global_Methods.username); Fill_data(); textBoxes = new List <TextBox>() { txt_carbohydrates, txt_fat, txt_kcal, txt_protein }; }