/// <summary> /// Добавляет указанного спортсмена в базу данных /// </summary> /// <param name="people"></param> /// <returns></returns> public void AddAthlete(Athlete athlete) { using (SQLiteCommand cmd = connection.CreateCommand()) { Dictionary<String, String> data = new Dictionary<string, string>(); data.Add("sportTypeId", athlete.sportTypeId.ToString()); data.Add("sportCategoryId", athlete.sportCategoryId.ToString()); data.Add("address", athlete.address); data.Add("place", athlete.place); data.Add("userId", athlete.userId.ToString()); data.Add("createDate", athlete.createDateInt64.ToString()); bool ok = Insert(cmd, TABLE_ATHLETE, data); if (!ok) throw new Exception("Не удалось добавить спортсмена!"); } }
/// <summary> /// Загружает информацию о текущем пользователе в контролы /// </summary> private void LoadUser() { user = sqlite.GetUser(userId); athlete = sqlite.GetAthleteByUserId(user.id); tbName.Text = string.Format("{0} {1} {2}", user.name, user.lastName, user.fatherName); tbBDay.Text = user.bDay; tbAddress.Text = athlete.address; tbPhone.Text = user.phone; tbPlace.Text = athlete.place; cbSportCategory.Text = sqlite.GetValueById(SQLite.TABLE_SPORT_CATEGORY, athlete.sportCategoryId); cbSportType.Text = sqlite.GetValueById(SQLite.TABLE_SPORT_TYPE, athlete.sportTypeId); cbSex.Text = user.sex; tbLogin.Text = user.login; tbPassword.Password = user.password; }