public Options() { _db = new dbDataContext(); _plstTimeZonesTables = _db.GetTable<playstation_timezone>(); _timeZonesTable = _db.GetTable<timezones_t>(); CacheDataFromDb(); }
private void button1_Click(object sender, EventArgs e) { // pers.AddNewPerson(personIdTextBox.Text, nameTextBox2.Text, loginTextBox3.Text, // passwordTextBox4.Text, positionTextBox5.Text, phoneTextBox6.Text, // additionalPhoneTextBox7.Text, birthdayDateTimePicker1.Value, homeAddressTextBox9.Text, // int.Parse(salaryTextBox10.Text)); var db = new dbDataContext(); Table<personal_info_t> t = db.GetTable<personal_info_t>(); var id = (from a in db.GetTable<personal_info_t>() orderby a.person_id ascending //select a.person_id).First(); select new {a.person_id}); dataGridView1.DataSource = id; //pers.GetAllPersonalInfos(); }
public void GetPricesFromDb() { db = new dbDataContext(); CurrentPlaystationPrice = new Dictionary<string, double>(); var timezone = (from t in db.GetTable<timezones_t>() where t.timezone_start <= DateTime.Now.TimeOfDay where t.timezone_end > DateTime.Now.TimeOfDay select t.timezone_name).Single(); var playstationPrice = (from pp in db.GetTable<timezones_t>() where pp.timezone_name == timezone select new { pp.timezone_name // pp.timezone_cost_per_hour }).ToList(); // for (int i = 0; i < playstationPrice.Count; i++) // { // CurrentPlaystationPrice.Add(playstationPrice[i].timezone_name, // playstationPrice[i].timezone_cost_per_hour); // } // MessageBox.Show(CurrentPlaystationPrice.ToString()); }
public void AddNewPerson(string personID, string name, string login, string password, string position, string phone, string additionalPhone, DateTime birthday, string homeAddress, int salaryPerDay) { _dataContext = new dbDataContext(); _personalInfoTables = _dataContext.GetTable<personal_info_t>(); //var persons = personalInfoTables.Where(person => person.additional_phone == "000000").ToList(); personal_info_t myPerson = new personal_info_t(); myPerson.person_id = personID; myPerson.name = name; myPerson.staff_login = login; myPerson.staff_password = password; myPerson.position = position; myPerson.phone = phone; myPerson.additional_phone = additionalPhone; myPerson.birthday = birthday; myPerson.home_address = homeAddress; myPerson.salary_per_day = salaryPerDay; _personalInfoTables.InsertOnSubmit(myPerson); _dataContext.SubmitChanges(); }