public ClientView(int pIdClient) { InitializeComponent(); idClient = pIdClient; try { using (CRM_magEntities contextDB = new CRM_magEntities()) { ClientView_Result clv = contextDB.ClientView(idClient).FirstOrDefault(); if (clv.famil != null) { txtbFamilCl.Text = clv.famil; } if (clv.f_name != null) { txtbNameCl.Text = clv.f_name; } if (clv.s_name != null) { txtbSurnameCl.Text = clv.s_name; } if (clv.number_pasp != null) { txtbPasp.Text = clv.number_pasp; } if (clv.tel != null) { txtbTel.Text = clv.tel; } if (clv.city_town != null) { txtbCityTown.Text = clv.city_town; } if (clv.city_town == "Москва") { rbtnMoscow.IsChecked = true; } else { rbtnMO.IsChecked = true; } if (clv.street != null) { txtbStreet.Text = clv.street; } if (clv.house != null) { txtbHouse.Text = clv.house.ToString(); } if (clv.korp != null) { txtbKorp.Text = clv.korp; } if (clv.flat != null) { txtbFlat.Text = clv.flat.ToString(); } if (clv.podezd != null) { txtbPodezd.Text = clv.podezd.ToString(); } if (clv.etag != null) { txtbEtag.Text = clv.etag.ToString(); } if (clv.domofon != null) { txtbDomofon.Text = clv.domofon; } if (clv.id_metro != null) { txtBMetro.Text = contextDB.Metro .Where(c => c.id_metro == clv.id_metro) .FirstOrDefault() .name_metro .ToString(); } if (clv.raion != null) { txtbRajon.Text = clv.raion; } if (clv.kol_hol != null) { txtbKolHol.Text = clv.kol_hol.ToString(); } if (clv.id_hol_schetch != null) { txtbMarkaHol.Text = contextDB.Request_snab.Where(c => c.id_hol_schetch == clv.id_hol_schetch) .FirstOrDefault().H_Schetchik.marka_hol_schetch.ToString(); } if (clv.kol_gor != null) { txtbKolGor.Text = clv.kol_gor.ToString(); } if (clv.id_gor_schetch != null) { txtbMarkaGor.Text = contextDB.Request_snab.Where(c => c.id_gor_schetch == clv.id_gor_schetch) .FirstOrDefault().G_Schetchik.marka_gor_schetch.ToString(); } if (clv.kol_teplo != null) { txtbKolTeplo.Text = clv.kol_teplo.ToString(); } if (clv.id_teplo_schetch != null) { txtbMarkaTeplo.Text = contextDB.Request_snab.Where(c => c.id_teplo_schetch == clv.id_teplo_schetch) .FirstOrDefault().Teplo_Schetchik.marka_teplo_schetch.ToString(); } if (clv.datetime_vyezda_montazhnika != null) { txtbVyezd.Text = ((DateTime)clv.datetime_vyezda_montazhnika).ToString("dd.MM.yyyy"); } if (clv.date_execution != null) { txtbDateExecution.Text = ((DateTime)clv.date_execution).ToString("dd.MM.yyyy"); } if (clv.id_mont != null) { txtbMont.Text = contextDB.Request_attachment .Where(c => c.id_mont == clv.id_mont) .FirstOrDefault() .Montazhniki.full_name .ToString(); } if (clv.sum_contract != null) { txtbSum.Text = clv.sum_contract.ToString(); } if (clv.id_request != null) { txtbNumberRequest.Text = clv.id_request.ToString(); } if (clv.date_request != null) { txtbDateReg.Text = ((DateTime)clv.date_request).ToString("dd.MM.yyyy"); } if (clv.dispetcher != null) { txtbDispR.Text = clv.dispetcher; } if (clv.kind_of_work != null) { txtbKindOfWork.Text = contextDB.Request_reception .Where(c => c.id_kind_of_work == clv.id_kind_of_work) .FirstOrDefault() .Kind_of_work .kind_of_work1 .ToString(); } if (clv.status != null) { txtbStatus.Text = clv.status; } if (clv.date_otkaza != null) { txtbDateOtkaz.Text = ((DateTime)clv.date_otkaza).ToString("dd.MM.yyyy"); } if (clv.reason_otkaza != null) { txtbReasonOtkaza.Text = clv.reason_otkaza; } } } catch (Exception e) { MessageBox.Show(e.ToString()); } }
public ClientUpdate(int pIdClient) { InitializeComponent(); idClient = pIdClient; try { using (CRM_magEntities contextDB = new CRM_magEntities()) { ClientView_Result clv = contextDB.ClientView(idClient).FirstOrDefault(); idAdrInst = Convert.ToInt32(clv.id_adr_installation); idClient = Convert.ToInt32(clv.id_client); idReqSnab = Convert.ToInt32(clv.id_request_snab); idReqAtt = Convert.ToInt32(clv.id_request_execution); idReqBuhg = Convert.ToInt32(clv.id_request_buhg); idReqRec = Convert.ToInt32(clv.id_request); if (clv.famil != null) { txtbFamilCl.Text = clv.famil; } if (clv.f_name != null) { txtbNameCl.Text = clv.f_name; } if (clv.s_name != null) { txtbSurnameCl.Text = clv.s_name; } if (clv.number_pasp != null) { txtbPasp.Text = clv.number_pasp; } if (clv.tel != null) { txtbTel.Text = clv.tel; } if (clv.city_town != null) { txtbCityTown.Text = clv.city_town; } if (clv.city_town == "Москва") { rbtnMoscow.IsChecked = true; } else { rbtnMO.IsChecked = true; } if (clv.street != null) { txtbStreet.Text = clv.street; } if (clv.house != null) { txtbHouse.Text = clv.house.ToString(); } if (clv.korp != null) { txtbKorp.Text = clv.korp; } if (clv.flat != null) { txtbFlat.Text = clv.flat.ToString(); } if (clv.podezd != null) { txtbPodezd.Text = clv.podezd.ToString(); } if (clv.etag != null) { txtbEtag.Text = clv.etag.ToString(); } if (clv.domofon != null) { txtbDomofon.Text = clv.domofon; } var dataMetro = from me in contextDB.Metro select new { me.id_metro, me.name_metro }; cmbMetro.ItemsSource = dataMetro.ToList(); cmbMetro.DisplayMemberPath = "name_metro"; cmbMetro.SelectedValuePath = "id_metro"; if (clv.id_metro != null) { cmbMetro.SelectedValue = clv.id_metro; } if (clv.raion != null) { txtbRajon.Text = clv.raion; } if (clv.kol_hol != null) { txtbKolHol.Text = clv.kol_hol.ToString(); } var dataMarkaHol = from mh in contextDB.H_Schetchik select new { mh.id_hol_schetch, mh.marka_hol_schetch }; cmbMarkaHol.ItemsSource = dataMarkaHol.ToList(); cmbMarkaHol.DisplayMemberPath = "marka_hol_schetch"; cmbMarkaHol.SelectedValuePath = "id_hol_schetch"; if (clv.id_hol_schetch != null) { cmbMarkaHol.SelectedValue = clv.id_hol_schetch; } if (clv.kol_gor != null) { txtbKolGor.Text = clv.kol_gor.ToString(); } var dataMarkaGor = from mg in contextDB.G_Schetchik select new { mg.id_gor_schetch, mg.marka_gor_schetch }; cmbMarkaGor.ItemsSource = dataMarkaGor.ToList(); cmbMarkaGor.DisplayMemberPath = "marka_gor_schetch"; cmbMarkaGor.SelectedValuePath = "id_gor_schetch"; if (clv.id_gor_schetch != null) { cmbMarkaGor.SelectedValue = clv.id_gor_schetch; } if (clv.kol_teplo != null) { txtbKolTeplo.Text = clv.kol_teplo.ToString(); } var dataMarkaTeplo = from mt in contextDB.Teplo_Schetchik select new { mt.id_teplo_schetch, mt.marka_teplo_schetch }; cmbMarkaTeplo.ItemsSource = dataMarkaTeplo.ToList(); cmbMarkaTeplo.DisplayMemberPath = "marka_teplo_schetch"; cmbMarkaTeplo.SelectedValuePath = "id_teplo_schetch"; if (clv.id_teplo_schetch != null) { cmbMarkaTeplo.SelectedValue = clv.id_teplo_schetch; } if (clv.datetime_vyezda_montazhnika != null) { txtbVyezd.Text = ((DateTime)clv.datetime_vyezda_montazhnika).ToString("dd.MM.yyyy"); } if (clv.date_execution != null) { txtbDateExecution.Text = ((DateTime)clv.date_execution).ToString("dd.MM.yyyy"); } var dataMont = from m in contextDB.Montazhniki select new { m.id_mont, m.full_name }; cmbMont.ItemsSource = dataMont.ToList(); cmbMont.DisplayMemberPath = "full_name"; cmbMont.SelectedValuePath = "id_mont"; if (clv.id_mont != null) { cmbMont.SelectedValue = clv.id_mont; } if (clv.dispetcher != null) { txtbDisp.Text = clv.dispetcher; } if (clv.date_request != null) { txtbDTRegistr.Text = ((DateTime)clv.date_request).ToString("dd.MM.yyyy"); } if (clv.sum_contract != null) { txtbSum.Text = clv.sum_contract.ToString(); } if (clv.id_request != null) { txtbNumberRequest.Text = clv.id_request.ToString(); } if (clv.date_otkaza != null) { txtbDateOtkaz.Text = ((DateTime)clv.date_otkaza).ToString("dd.MM.yyyy"); } if (clv.reason_otkaza != null) { txtbReasonOtkaza.Text = clv.reason_otkaza; } var dataKindOfWork = from k in contextDB.Kind_of_work select new { k.id_kind_of_work, k.kind_of_work1 }; cmbKindOfWork.ItemsSource = dataKindOfWork.ToList(); cmbKindOfWork.DisplayMemberPath = "kind_of_work1"; cmbKindOfWork.SelectedValuePath = "id_kind_of_work"; if (clv.kind_of_work != null) { cmbKindOfWork.SelectedValue = clv.id_kind_of_work; } var dataStatus = from s in contextDB.Status select new { s.id_status, s.status1 }; cmbStatus.ItemsSource = dataStatus.ToList(); cmbStatus.DisplayMemberPath = "status1"; cmbStatus.SelectedValuePath = "id_status"; if (clv.status != null) { cmbStatus.SelectedValue = clv.id_status; } } } catch (Exception e) { MessageBox.Show(e.ToString()); } try { using (CRM_magEntities contextDB = new CRM_magEntities()) { txtbNumberRequest.IsEnabled = false; } } catch (Exception e) { MessageBox.Show(e.ToString()); } }