コード例 #1
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (id == -1)
         {
             int addId = TablesModel.entities.ZIPPMonStock.Count() == 0 ? 0 : TablesModel.entities.ZIPPMonStock.Max(x => x.zipPM_on_stock_id) + 1;
             TablesModel.entities.ZIPPMonStock.Add(new Models.ZIPPMonStock()
             {
                 zipPM_on_stock_id = addId,
                 count             = int.Parse(textBoxSize.Text),
                 zipPM_element_id  = (int)comboBoxZIPPM.SelectedValue,
                 other             = ".."
             });
         }
         else
         {
             var el = TablesModel.entities.ZIPPMonStock.Where(x => x.zipPM_on_stock_id == id).First();
             el.count            = int.Parse(textBoxSize.Text);
             el.zipPM_element_id = (int)comboBoxZIPPM.SelectedValue;
         }
         TablesModel.entities.SaveChanges();
         var frm = DBEditing.getInstanceDB();
         if (frm != null)
         {
             frm.UPdateDB();
         }
         MessageBox.Show("изменения успешно приняты");
         this.Close();
     }
     catch (Exception ee)
     {
         MessageBox.Show("Введены некорректные данные");
     }
 }
コード例 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.ZIPPMMoves.Count() == 0 ? 0 : TablesModel.entities.ZIPPMMoves.Max(x => x.zipPM_move_id) + 1;
                    var el    = new Models.ZIPPMMoves()
                    {
                        zipPM_move_id    = addId,
                        date_move        = dateTimePickerMoved.Value,
                        zipPM_element_id = (int)comboBoxZIPPm.SelectedValue,
                        model_element_id = (int)comboBoxModel.SelectedValue
                    };
                    TablesModel.entities.ZIPPMMoves.Add(el);
                    TablesModel.entities.SaveChanges();
                    var element_ZIPPM = TablesModel.entities.ZIPPMonStock.Where(x => x.sp_ZIP_AND_PM_Element.zipPM_element_id == el.zipPM_element_id).FirstOrDefault();
                    if (element_ZIPPM.count <= 0)
                    {
                        throw new ArgumentException();
                    }
                    else
                    {
                        element_ZIPPM.count -= 1;
                    }

                    TablesModel.entities.SaveChanges();
                }
                else
                {
                    var el = TablesModel.entities.ZIPPMMoves.Where(x => x.zipPM_move_id == id).First();
                    el.date_move        = dateTimePickerMoved.Value;
                    el.zipPM_element_id = (int)comboBoxZIPPm.SelectedValue;
                    el.model_element_id = (int)comboBoxModel.SelectedValue;
                }



                TablesModel.entities.SaveChanges();
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");
                this.Close();
            }
            catch (ArgumentException ee)
            {
                MessageBox.Show("детали закончились на складе!");
                return;
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #3
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (id == -1)
         {
             int addId = TablesModel.entities.ModelElement.Count() == 0 ? 0 : TablesModel.entities.ModelElement.Max(x => x.model_element_id) + 1;
             TablesModel.entities.ModelElement.Add(new Models.ModelElement()
             {
                 model_element_id    = addId,
                 inventory_number    = textBoxInventaryNumber.Text,
                 serial_number       = textBoxSerialNumber.Text,
                 date_creation       = dateTimePickerCreated.Value,
                 date_utilisation    = dateTimePickerWriteOff.Value,
                 model_type_id       = (int)comboBoxModelType.SelectedValue,
                 reason_write_off_id = (int)comboBoxWriteOffReason.SelectedValue,
                 other   = textBoxName.Text,
                 is_mo   = checkBox1.Checked ? 1 : 0,
                 date_mo = dateTimePickerMO.Value,
                 date_to = dateTimePickerTO.Value
             });
             TablesModel.entities.SaveChanges();
         }
         else
         {
             var el = TablesModel.entities.ModelElement.Where(x => x.model_element_id == id).First();
             el.inventory_number    = textBoxInventaryNumber.Text;
             el.serial_number       = textBoxSerialNumber.Text;
             el.date_creation       = dateTimePickerCreated.Value;
             el.date_utilisation    = dateTimePickerWriteOff.Value;
             el.model_type_id       = (int)comboBoxModelType.SelectedValue;
             el.reason_write_off_id = (int)comboBoxWriteOffReason.SelectedValue;
             el.other = textBoxName.Text;
             TablesModel.entities.SaveChanges();
         }
         var frm = DBEditing.getInstanceDB();
         if (frm != null)
         {
             frm.UPdateDB();
         }
         MessageBox.Show("изменения успешно приняты");
         this.Close();
     }
     catch (Exception ee)
     {
         MessageBox.Show("Введены некорректные данные");
     }
 }
コード例 #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.FaticalPhysicalPeoplePositions.Count() == 0 ? 0 : TablesModel.entities.FaticalPhysicalPeoplePositions.Max(x => x.fatical_physical_people_position_id) + 1;
                    TablesModel.entities.FaticalPhysicalPeoplePositions.Add(new Models.FaticalPhysicalPeoplePositions()
                    {
                        fatical_physical_people_position_id = addId,
                        date_begin         = dateTimePickerBegin.Value,
                        date_end           = dateTimePickerEnd.Value,
                        salary             = int.Parse(textBoxSalary.Text),
                        people_position_id = (int)comboBoxPosition.SelectedValue,
                        physical_people_id = (int)comboBoxFIO.SelectedValue,
                        organisation_id    = (int)comboBoxOrganisation.SelectedValue
                    });
                    TablesModel.entities.SaveChanges();
                }
                else
                {
                    var el = TablesModel.entities.FaticalPhysicalPeoplePositions.Where(x => x.fatical_physical_people_position_id == id).First();
                    el.date_begin         = dateTimePickerBegin.Value;
                    el.date_end           = dateTimePickerEnd.Value;
                    el.salary             = int.Parse(textBoxSalary.Text);
                    el.people_position_id = (int)comboBoxPosition.SelectedValue;

                    el.physical_people_id = (int)comboBoxFIO.SelectedValue;
                    el.organisation_id    = (int)comboBoxOrganisation.SelectedValue;

                    TablesModel.entities.SaveChanges();
                }
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");
                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #5
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.PhysicalPeople.Count() == 0 ? 0 : TablesModel.entities.PhysicalPeople.Max(x => x.physical_people_id) + 1;
                    TablesModel.entities.PhysicalPeople.Add(new Models.PhysicalPeople()
                    {
                        physical_people_id = addId,
                        name       = textBoxName.Text,
                        family     = textBoxFam.Text,
                        patronumic = textBoxPatr.Text,
                        contacts   = textBoxContacts.Text,
                        organisation_department_id = (int)comboBoxDep.SelectedValue,
                        Gender = comboBoxGender.SelectedIndex
                    });
                    TablesModel.entities.SaveChanges();
                }
                else
                {
                    var el = TablesModel.entities.PhysicalPeople.Where(x => x.physical_people_id == id).First();
                    el.name       = textBoxName.Text;
                    el.family     = textBoxFam.Text;
                    el.patronumic = textBoxPatr.Text;
                    el.contacts   = textBoxContacts.Text;

                    el.organisation_department_id = (int)comboBoxDep.SelectedValue;
                    el.Gender = comboBoxGender.SelectedIndex;

                    TablesModel.entities.SaveChanges();
                }
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");
                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #6
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.PersonalOnService.Count() == 0 ? 0 : TablesModel.entities.PersonalOnService.Max(x => x.personal_on_service_id) + 1;
                    TablesModel.entities.PersonalOnService.Add(new Models.PersonalOnService()
                    {
                        personal_on_service_id             = addId,
                        physical_people_id                 = (int)comboBoxFIO.SelectedValue,
                        service_type_id                    = (int)comboBoxServiceType.SelectedValue,
                        service_operation_type_id          = (int)comboBoxServiceOperation.SelectedValue,
                        service_operation_personal_role_id = (int)comboBoxRole.SelectedValue,
                        model_element_id                   = (int)comboBoxModelElement.SelectedValue
                    });
                    TablesModel.entities.SaveChanges();
                }
                else
                {
                    var el = TablesModel.entities.PersonalOnService.Where(x => x.personal_on_service_id == id).First();
                    el.physical_people_id                 = (int)comboBoxFIO.SelectedValue;
                    el.service_type_id                    = (int)comboBoxServiceType.SelectedValue;
                    el.service_operation_type_id          = (int)comboBoxServiceOperation.SelectedValue;
                    el.service_operation_personal_role_id = (int)comboBoxRole.SelectedValue;

                    el.physical_people_id = (int)comboBoxFIO.SelectedValue;
                    el.model_element_id   = (int)comboBoxModelElement.SelectedValue;

                    TablesModel.entities.SaveChanges();
                }
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");
                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #7
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.MOExpluatation.Count() == 0 ? 0 : TablesModel.entities.MOExpluatation.Max(x => x.mo_expluatation_id) + 1;
                    TablesModel.entities.MOExpluatation.Add(new Models.MOExpluatation()
                    {
                        mo_expluatation_id = addId,
                        date_begin         = dateTimePickerBegin.Value,
                        date_end           = dateTimePickerEnd.Value,
                        service_operation_personal_role_id = (int)comboBoxRole.SelectedValue,
                        physical_people_id = (int)comboBoxFIO.SelectedValue,
                        model_element_id   = (int)comboBoxModel.SelectedValue
                    });
                    TablesModel.entities.SaveChanges();
                }
                else
                {
                    var el = TablesModel.entities.MOExpluatation.Where(x => x.mo_expluatation_id == id).First();
                    el.date_begin       = dateTimePickerBegin.Value;
                    el.date_end         = dateTimePickerEnd.Value;
                    el.model_element_id = (int)comboBoxModel.SelectedValue;

                    el.physical_people_id = (int)comboBoxFIO.SelectedValue;
                    el.service_operation_personal_role_id = (int)comboBoxRole.SelectedValue;

                    TablesModel.entities.SaveChanges();
                }
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");
                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #8
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (id == -1)
         {
             int addId = TablesModel.entities.ElementsPlaces.Count() == 0 ? 0 : TablesModel.entities.ElementsPlaces.Max(x => x.element_place_id) + 1;
             TablesModel.entities.ElementsPlaces.Add(new Models.ElementsPlaces()
             {
                 element_place_id = addId,
                 date_begin       = dateTimePickerMoved.Value,
                 date_end         = dateTimePickerMoved.Value,
                 corpus_id        = (int)comboBoxCorpus.SelectedValue,
                 floor            = 0,
                 room             = "..",
                 model_element_id = (int)comboBoxModelElement.SelectedValue,
                 move_reason_id   = (int)comboBoxMoveReason.SelectedValue
             });
         }
         else
         {
             var el = TablesModel.entities.ElementsPlaces.Where(x => x.element_place_id == id).First();
             el.date_begin       = dateTimePickerMoved.Value;
             el.date_end         = dateTimePickerMoved.Value;
             el.corpus_id        = (int)comboBoxCorpus.SelectedValue;
             el.model_element_id = (int)comboBoxModelElement.SelectedValue;
             el.move_reason_id   = (int)comboBoxMoveReason.SelectedValue;
         }
         TablesModel.entities.SaveChanges();
         var frm = DBEditing.getInstanceDB();
         if (frm != null)
         {
             frm.UPdateDB();
         }
         MessageBox.Show("изменения успешно приняты");
         this.Close();
     }
     catch (Exception ee)
     {
         MessageBox.Show("Введены некорректные данные");
     }
 }
コード例 #9
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.BrokenRequest.Count() == 0 ? 0 : TablesModel.entities.BrokenRequest.Max(x => x.broken_request_id) + 1;
                    TablesModel.entities.BrokenRequest.Add(new Models.BrokenRequest()
                    {
                        broken_request_id        = addId,
                        date_to_repair           = dateTimePickerMoved.Value,
                        model_element_id         = (int)comboBoxModel.SelectedValue,
                        physical_people_id       = (int)comboBoxPeople.SelectedValue,
                        broken_request_reason_id = (int)comboBoxBroken.SelectedValue,
                        isFinished = checkBox1.Checked ? 1 : 0
                    });
                }
                else
                {
                    var el = TablesModel.entities.BrokenRequest.Where(x => x.broken_request_id == id).First();
                    el.date_to_repair     = dateTimePickerMoved.Value;
                    el.broken_request_id  = (int)comboBoxBroken.SelectedValue;
                    el.model_element_id   = (int)comboBoxModel.SelectedValue;
                    el.physical_people_id = (int)comboBoxPeople.SelectedValue;
                    el.isFinished         = checkBox1.Checked ? 1 : 0;
                }
                TablesModel.entities.SaveChanges();
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");

                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #10
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.PurchaseElements.Count() == 0 ? 0 : TablesModel.entities.PurchaseElements.Max(x => x.purchase_element_id) + 1;
                    TablesModel.entities.PurchaseElements.Add(new Models.PurchaseElements()
                    {
                        purchase_element_id = addId,
                        isPurchasing        = checkBox1.Checked ? 1 : 0,
                        count            = int.Parse(textBoxCount.Text),
                        money            = int.Parse(textBoxMoney.Text),
                        model_element_id = int.Parse((string)comboBoxModelElement.SelectedValue),
                        planned_date     = dateTimePickerMoved.Value
                    });
                }
                else
                {
                    var el = TablesModel.entities.PurchaseElements.Where(x => x.purchase_element_id == id).First();
                    el.isPurchasing     = checkBox1.Checked ? 1 : 0;
                    el.count            = int.Parse(textBoxCount.Text);
                    el.money            = int.Parse(textBoxMoney.Text);
                    el.model_element_id = int.Parse((string)comboBoxModelElement.SelectedValue);
                    el.planned_date     = dateTimePickerMoved.Value;
                }

                TablesModel.entities.SaveChanges();
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");
                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #11
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (id == -1)
         {
             int addId = TablesModel.entities.ModelType.Count() == 0 ? 0 : TablesModel.entities.ModelType.Max(x => x.model_type_id) + 1;
             TablesModel.entities.ModelType.Add(new Models.ModelType()
             {
                 model_type_id            = addId,
                 expluatation_role_id     = (int)comboBoxExpluatation.SelectedValue,
                 organisation_id          = (int)comboBoxOrganisation.SelectedValue,
                 functionaly_use_model_id = (int)comboBoxFunc.SelectedValue,
                 model_type_name          = textBoxName.Text
             });
             TablesModel.entities.SaveChanges();
         }
         else
         {
             var el = TablesModel.entities.ModelType.Where(x => x.model_type_id == id).First();
             el.model_type_name          = textBoxName.Text;
             el.organisation_id          = (int)comboBoxOrganisation.SelectedValue;
             el.functionaly_use_model_id = (int)comboBoxFunc.SelectedValue;
             el.expluatation_role_id     = (int)comboBoxExpluatation.SelectedValue;
             TablesModel.entities.SaveChanges();
         }
         var frm = DBEditing.getInstanceDB();
         if (frm != null)
         {
             frm.UPdateDB();
         }
         MessageBox.Show("изменения успешно приняты");
         this.Close();
     }
     catch (Exception ee)
     {
         MessageBox.Show("Введены некорректные данные");
     }
 }
コード例 #12
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (id == -1)
                {
                    int addId = TablesModel.entities.ZIPPMDocumentsOnPurchase.Count() == 0 ? 0 : TablesModel.entities.ZIPPMDocumentsOnPurchase.Max(x => x.zipPM_documents_purchase_id) + 1;
                    TablesModel.entities.ZIPPMDocumentsOnPurchase.Add(new Models.ZIPPMDocumentsOnPurchase()
                    {
                        zipPM_documents_purchase_id = addId,
                        zipPM_element_id            = (int)comboBoxModelElement.SelectedValue,
                        count                    = int.Parse(textBoxCount.Text),
                        date_coming_in           = dateTimePickerPlanned.Value,
                        date_to_end_possible_use = dateTimePickerFactical.Value
                    });
                }
                else
                {
                    var el = TablesModel.entities.ZIPPMDocumentsOnPurchase.Where(x => x.zipPM_documents_purchase_id == id).First();
                    el.date_coming_in           = dateTimePickerPlanned.Value;
                    el.date_to_end_possible_use = dateTimePickerFactical.Value;
                    el.count            = int.Parse(textBoxCount.Text);
                    el.zipPM_element_id = (int)comboBoxModelElement.SelectedValue;
                }
                TablesModel.entities.SaveChanges();
                var frm = DBEditing.getInstanceDB();
                if (frm != null)
                {
                    frm.UPdateDB();
                }
                MessageBox.Show("изменения успешно приняты");

                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("Введены некорректные данные");
            }
        }
コード例 #13
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (id == -1)
         {
             int addId = TablesModel.entities.ElementsDragMetal.Count() == 0 ? 0 : TablesModel.entities.ElementsDragMetal.Max(x => x.elements_drag_metal_id) + 1;
             TablesModel.entities.ElementsDragMetal.Add(new Models.ElementsDragMetal()
             {
                 elements_drag_metal_id = addId,
                 model_element_id       = (int)comboBoxModel.SelectedValue,
                 drag_metal_id          = (int)comboBoxDragMetal.SelectedValue,
                 size = int.Parse(textBoxSize.Text)
             });
             TablesModel.entities.SaveChanges();
         }
         else
         {
             var el = TablesModel.entities.ElementsDragMetal.Where(x => x.elements_drag_metal_id == id).First();
             el.model_element_id = (int)comboBoxModel.SelectedValue;
             el.drag_metal_id    = (int)comboBoxDragMetal.SelectedValue;
             el.size             = int.Parse(textBoxSize.Text);
             TablesModel.entities.SaveChanges();
         }
         var frm = DBEditing.getInstanceDB();
         if (frm != null)
         {
             frm.UPdateDB();
         }
         MessageBox.Show("изменения успешно приняты");
         this.Close();
     }
     catch (Exception ee)
     {
         MessageBox.Show("Введены некорректные данные");
     }
 }
コード例 #14
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (id == -1)
         {
             int addId = TablesModel.entities.Purchase.Count() == 0 ? 0 : TablesModel.entities.Purchase.Max(x => x.purchase_id) + 1;
             TablesModel.entities.Purchase.Add(new Models.Purchase()
             {
                 purchase_id = addId,
                 date_apply  = dateTimePickerCreated.Value,
                 purchase_document_number = textBoxDocNumber.Text,
                 purchase_type_id         = (int)comboBoxPurchaseType.SelectedValue
             });
         }
         else
         {
             var el = TablesModel.entities.Purchase.Where(x => x.purchase_id == id).First();
             el.date_apply = dateTimePickerCreated.Value;
             el.purchase_document_number = textBoxDocNumber.Text;
             el.purchase_type_id         = (int)comboBoxPurchaseType.SelectedValue;
         }
         TablesModel.entities.SaveChanges();
         var frm = DBEditing.getInstanceDB();
         if (frm != null)
         {
             frm.UPdateDB();
         }
         MessageBox.Show("изменения успешно приняты");
         this.Close();
     }
     catch (Exception ee)
     {
         MessageBox.Show("Введены некорректные данные");
     }
 }