private void FillPriceForPtich() { if (CmbPitch.SelectedItem != null) { Meydancalar meydanca = new Meydancalar(); meydanca = db.Meydancalars.FirstOrDefault(m => m.Name == CmbPitch.Text); cmbPrice.Items.Add(meydanca.Price); //MessageBox.Show(meydanca.Price.ToString()); } }
private void FillTime() { /////////// TIME ////////// if (string.IsNullOrEmpty(CmbPitch.Text)) { MessageBox.Show("Select Pitch"); return; } CmbTime.Items.Clear(); CmbTime.Text = ""; CmbPerson.Items.Clear(); lblPerson.Visible = false; CmbPerson.Visible = false; CmbPerson.Text = ""; BtnAddMushteri.Visible = false; Meydancalar myd = db.Meydancalars.FirstOrDefault(m => m.Name == CmbPitch.Text); { //MessageBox.Show(myd.Name.ToString()); } int interval = (int)(endTime.Subtract(startTime).TotalHours + 24); TimeSpan tmpTime = startTime; for (int i = 0; i < interval; i++) { int count = db.Bookings.Where(b => b.MeydancaId == myd.Id && b.Date == dtpDate.Value.Date && b.Time == tmpTime).Count(); if (count == 0) { CmbTime.Items.Add(tmpTime.ToString(@"hh\:mm")); } tmpTime = tmpTime.Add(new TimeSpan(1, 0, 0)); if (tmpTime.Hours == 0) { tmpTime = new TimeSpan(1, 0, 0); } } //MessageBox.Show((endTime.Subtract(startTime).TotalHours+24).ToString()); //Otaqlar oty = db.Otaqlars.FirstOrDefault(o => o.Number == cmbRoom); }