private void btnSave_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         using (CRM_magEntities contextDB = new CRM_magEntities())
         {
             foreach (var item in unsd)
             {
                 int idRA = Convert.ToInt32(contextDB.Request_reception.Find(item.NumberRequest).id_request_execution);
                 Request_attachment ra = contextDB.Request_attachment.Find(idRA);
                 ra.id_mont = item.IdMont;
             }
             contextDB.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }
예제 #2
0
        private void btnOKFizL_Click(object sender, RoutedEventArgs e)
        {
            if (IsErrorFizLico())
            {
                MessageBox.Show(sErrorFizLico, "Ошибка!");
            }
            else
            {
                try
                {
                    using (CRM_magEntities contextDB = new CRM_magEntities())
                    {
                        Client cl = new Client();

                        cl.famil       = txtbFamilCl.Text;
                        cl.f_name      = txtbNameCl.Text;
                        cl.s_name      = txtbSurnameCl.Text;
                        cl.number_pasp = txtbPasp.Text;
                        cl.tel         = txtbTel.Text;
                        contextDB.Client.Add(cl);
                        contextDB.SaveChanges();
                        idClient = cl.id_client;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }


            if (!IsErrorFizLico())
            {
                try
                {
                    using (CRM_magEntities contextDB = new CRM_magEntities())
                    {
                        Adr_installation adr = new Adr_installation();
                        if (rbtnMoscow.IsChecked == true)
                        {
                            adr.city_town = "Москва";
                        }
                        else if (rbtnMO.IsChecked == true)
                        {
                            adr.city_town = txtbCityTown.Text;
                        }
                        adr.raion = txtbRajon.Text;
                        if (txtbStreet.Text != null)
                        {
                            adr.street = txtbStreet.Text;
                        }
                        adr.house = Convert.ToInt32(txtbHouse.Text);
                        adr.korp  = txtbKorp.Text;
                        adr.flat  = Convert.ToInt32(txtbFlat.Text);
                        if (cmbMetro.SelectedValue != null)
                        {
                            adr.id_metro = Convert.ToInt32(cmbMetro.SelectedValue);
                        }

                        adr.podezd    = Convert.ToInt32(txtbPodezd.Text);
                        adr.etag      = Convert.ToInt32(txtbEtag.Text);
                        adr.domofon   = txtbDomofon.Text;
                        adr.id_client = idClient;
                        contextDB.Adr_installation.Add(adr);
                        contextDB.SaveChanges();
                        idAdrInst = adr.id_adr_installation;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }


            if (!IsErrorFizLico())
            {
                try
                {
                    using (CRM_magEntities contextDB = new CRM_magEntities())
                    {
                        Request_snab rs = new Request_snab();
                        if (cmbMarkaGor.SelectedValue != null)
                        {
                            rs.id_gor_schetch = Convert.ToInt32(cmbMarkaGor.SelectedValue);
                        }
                        if (cmbMarkaHol.SelectedValue != null)
                        {
                            rs.id_hol_schetch = Convert.ToInt32(cmbMarkaHol.SelectedValue);
                        }
                        if (cmbMarkaTeplo.SelectedValue != null)
                        {
                            rs.id_teplo_schetch = Convert.ToInt32(cmbMarkaTeplo.SelectedValue);
                        }
                        int  numbKolGor;
                        bool resultKolGor = int.TryParse(txtbKolGor.Text, out numbKolGor);
                        if (resultKolGor == true)
                        {
                            rs.kol_gor = numbKolGor;
                        }

                        int  numbKolHol;
                        bool resultKolHol = int.TryParse(txtbKolHol.Text, out numbKolHol);
                        if (resultKolHol == true)
                        {
                            rs.kol_hol = numbKolHol;
                        }

                        int  numbKolTeplo;
                        bool resultKolTeplo = int.TryParse(txtbKolTeplo.Text, out numbKolTeplo);
                        if (resultKolTeplo == true)
                        {
                            rs.kol_teplo = numbKolTeplo;
                        }

                        contextDB.Request_snab.Add(rs);
                        contextDB.SaveChanges();

                        idReqSnab = rs.id_request_snab;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }


            if (!IsErrorFizLico())
            {
                try
                {
                    using (CRM_magEntities contextDB = new CRM_magEntities())
                    {
                        Request_attachment ra = new Request_attachment();
                        ra.datetime_vyezda_montazhnika = Convert
                                                         .ToDateTime(txtbVyezd.Text);

                        if (cmbMont.SelectedValue != null)
                        {
                            ra.id_mont = Convert.ToInt32(cmbMont.SelectedValue);
                        }

                        contextDB.Request_attachment.Add(ra);
                        contextDB.SaveChanges();

                        idReqAtt = ra.id_request_execution;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }



            if (!IsErrorFizLico())
            {
                try
                {
                    using (CRM_magEntities contextDB = new CRM_magEntities())
                    {
                        Request_buhg rb = new Request_buhg();
                        decimal      sum;
                        bool         resultSum = decimal.TryParse(txtbSum.Text, out sum);
                        if (resultSum == true)
                        {
                            rb.sum_contract = sum;
                        }

                        contextDB.Request_buhg.Add(rb);
                        contextDB.SaveChanges();
                        idReqBuhg = rb.id_request_buhg;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }

            if (!IsErrorFizLico())
            {
                try
                {
                    using (CRM_magEntities contextDB = new CRM_magEntities())
                    {
                        Request_reception rr = new Request_reception();
                        rr.id_request_snab      = idReqSnab;
                        rr.id_request_buhg      = idReqBuhg;
                        rr.id_request_execution = idReqAtt;
                        rr.id_adr_installation  = idAdrInst;
                        rr.id_status            = 1;
                        rr.id_kind_of_work      = Convert.ToInt32(cmbKindOfWork.SelectedValue);
                        if (idPerenosReq != 0)
                        {
                            rr.id_perenos_request = idPerenosReq;
                        }
                        rr.dispetcher   = txtbDispR.Text;
                        rr.date_request = Convert.ToDateTime(txtbDateReg.Text);

                        contextDB.Request_reception.Add(rr);
                        contextDB.SaveChanges();
                        txtbNumberRequest.Text = rr.id_request.ToString();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
                if (evNewClient != null)
                {
                    evNewClient();
                }
            }
        }