private void dgClient_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (dgClient.SelectedItem != null) { long ID = Convert.ToInt64((dgClient.SelectedCells[0].Column.GetCellContent(dgClient.SelectedItem) as TextBlock).Text); model.ID_client = Convert.ToInt32(dgClient.SelectedIndex + 1); using (hair_salonEntities db = new hair_salonEntities()) { var queryInfo = from a in db.record join b in db.service on a.ID_service equals b.ID_service join c in db.client on a.ID_client equals c.ID_client join d in db.admin on a.ID_admin equals d.ID_admin join f in db.master on a.ID_master equals f.ID_master where c.ID_client == ID select new { b.name_service, a.datetime }; dgInfo.ItemsSource = queryInfo.ToList(); model = db.client.Where(x => x.ID_client == model.ID_client).FirstOrDefault(); txtSurname.Text = model.surname; } } } catch { MessageBox.Show("Не удалось выбрать клиента."); } }
public List <admin> Update() { hair_salonEntities entities = new hair_salonEntities(); var a = entities.admin.ToList(); return(a); }
public List <client> UpdateClient() { hair_salonEntities entities = new hair_salonEntities(); var a = entities.client.ToList(); return(a); }
private void btnAddRecord_Click(object sender, RoutedEventArgs e) { try { modelR.ID_client = Convert.ToInt32(dgClient.SelectedIndex + 1); //modelR.ID_master = modelM.ID_master; //modelS.ID_service = modelS.ID_service; //modelA.ID_admin = modelR.ID_admin; modelR.datetime = Convert.ToDateTime(dpRecord.Text); using (hair_salonEntities db = new hair_salonEntities()) { db.record.Add(modelR); db.SaveChanges(); } MessageBox.Show("Посещение добавлено."); dpRecord.Text = null; cmbService.Text = null; Upd(); } catch { MessageBox.Show("Не удалось добавить посещение."); } }
private void btnAddClient_Click(object sender, RoutedEventArgs e) { model.surname = txtSurname.Text.Trim(); using (hair_salonEntities db = new hair_salonEntities()) { db.client.Add(model); db.SaveChanges(); } MessageBox.Show("Клиент добавлен."); txtSurname.Text = null; Upd(); }
private void btnAddService_Click(object sender, RoutedEventArgs e) { modelS.name_service = txtNameService.Text.Trim(); modelS.price = Convert.ToDecimal(txtPriceService.Text.Trim()); using (hair_salonEntities db = new hair_salonEntities()) { db.service.Add(modelS); db.SaveChanges(); } MessageBox.Show("Услуга добавлена."); txtNameService.Text = null; txtPriceService.Text = null; Upd(); }
private void btnUpdateClient_Click(object sender, RoutedEventArgs e) { try { model.surname = txtSurname.Text.Trim(); using (hair_salonEntities db = new hair_salonEntities()) { db.Entry(model).State = EntityState.Modified; db.SaveChanges(); } MessageBox.Show("Клиент изменен."); Upd(); } catch { MessageBox.Show("Не удалось изменить клиента."); } }
private void btnUpdateService_Click(object sender, RoutedEventArgs e) { try { modelS.name_service = txtNameService.Text.Trim(); modelS.price = Convert.ToDecimal(txtPriceService.Text.Trim()); using (hair_salonEntities db = new hair_salonEntities()) { db.Entry(modelS).State = EntityState.Modified; db.SaveChanges(); } MessageBox.Show("Услуга изменена."); Upd(); } catch { MessageBox.Show("Не удалось изменить услугу."); } }
private void Upd() { hair_salonEntities db = new hair_salonEntities(); var data = from a in db.client select a; dgClient.ItemsSource = data.ToList(); var dataS = from a in db.service select a; dgService.ItemsSource = dataS.ToList(); var dataCmb = from a in db.service select new { a.name_service }; cmbService.ItemsSource = dataCmb.ToList(); //cmbService.Items.Add(dataCmb.ToString()); //this.cmbService.Items.Add(db.[0].ToString()); }
private void txtSearchOrder_TextChanged(object sender, TextChangedEventArgs e) { string str = txtSearchOrder.Text; if (str == "") { Upd(); } else { using (hair_salonEntities db = new hair_salonEntities()) { var querySearch = from c in db.client where c.surname.Contains(str) select c; dgClient.ItemsSource = querySearch.ToList(); } } }
private void dgService_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (dgService.SelectedItem != null) { modelS.ID_service = Convert.ToInt32(dgService.SelectedIndex + 1); using (hair_salonEntities db = new hair_salonEntities()) { modelS = db.service.Where(x => x.ID_service == modelS.ID_service).FirstOrDefault(); txtNameService.Text = modelS.name_service; txtPriceService.Text = Convert.ToString(modelS.price); } } } catch { MessageBox.Show("Не удалось выбрать услугу."); } }
private void btnEnter_Click(object sender, RoutedEventArgs e) { foreach (var s in Update()) { if (s.password == "000") { using (hair_salonEntities db = new hair_salonEntities()) { admin a = db.admin.FirstOrDefault(); a.password = txtPasswordUpdate.Password; db.SaveChanges(); } MessageBox.Show("Пароль успешно изменен"); break; } else { MessageBox.Show("Пароль уже был изменен"); break; } } this.Close(); }