Example #1
0
        private void simpleButtonAddUpdate_Click(object sender, EventArgs e)
        {
            using (var db = new PUEntitiesOne())
            {
                if (textEditFaculty.Text == null || textEditFaculty.Text == "")
                {
                    MessageBox.Show("Полето трябва да е запълнено");
                    return;
                }

                if (isUpdate)
                {
                    var row = db.Faculties.FirstOrDefault(x => x.id == data.id);
                    row.facultyName = textEditFaculty.Text;
                }
                else
                {
                    Faculty f = new Faculty();
                    f.facultyName = textEditFaculty.Text;
                    db.Faculties.Add(f);
                }

                try
                {
                    db.SaveChanges();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }

                this.Hide();
            }
        }
        private void DeleteOperation()
        {
            var cour = gridView.GetFocusedRow() as Cours;

            DialogResult dialogResult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                using (var db = new PUEntitiesOne())
                {
                    db.Courses.Attach(cour);
                    db.Courses.Remove(cour);

                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
                        return;
                    }
                }
            }
        }
        private void DeleteOperation()
        {
            var con = gridView.GetFocusedRow() as Contraget;

            DataCheck(con);

            DialogResult dialogResult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                using (var db = new PUEntitiesOne())
                {
                    db.Entry(con).State = System.Data.Entity.EntityState.Deleted;
                    db.Contragets.Remove(con);


                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
                        return;
                    }
                }
            }

            LoadData();
        }
Example #4
0
        private void DeleteOperation()
        {
            var edu = gridView.GetFocusedRow() as Educator;

            DataCheck(edu);

            DialogResult dialogResult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                using (var db = new PUEntitiesOne())
                {
                    //db.Entry(edu).State = EntityState.Deleted;
                    db.Educators.Attach(edu);
                    db.Educators.Remove(edu);

                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");

                        return;
                    }
                }
            }
        }
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            if (DataCheck())
            {
                return;
            }
            using (var db = new PUEntitiesOne())
            {
                if (isUpdate)
                {
                    var course = db.Courses.FirstOrDefault(x => x.id == cours.id);
                    course.protocol    = textEditProtocol.Text;
                    course.courseDate  = dateEdit1.DateTime;
                    course.theme       = textEditTheme.Text;
                    course.anotation   = textEditAnotation.Text;
                    course.totalHour   = int.Parse(textEditTotalHour.Text);
                    course.totalCredit = int.Parse(textEditTotalCredit.Text);
                    course.areaId      = int.Parse(treeListLookUpEdit1.EditValue.ToString());
                    course.educatorId  = int.Parse(treeListLookUpEdit2.EditValue.ToString());
                }
                else
                {
                    Cours course = new Cours();

                    course.protocol    = textEditProtocol.Text;
                    course.courseDate  = dateEdit1.DateTime;
                    course.theme       = textEditTheme.Text;
                    course.anotation   = textEditAnotation.Text;
                    course.totalHour   = int.Parse(textEditTotalHour.Text);
                    course.totalCredit = int.Parse(textEditTotalCredit.Text);
                    course.areaId      = int.Parse(treeListLookUpEdit1.EditValue.ToString());
                    course.educatorId  = int.Parse(treeListLookUpEdit2.EditValue.ToString());

                    db.Courses.Add(course);
                }

                try
                {
                    db.SaveChanges();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }

                this.Hide();
            }
        }
Example #6
0
        private void DeleteOperation()
        {
            var area = gridView1.GetFocusedRow() as Area;

            //id = int.Parse(gridView1.GetFocusedRowCellValue("id").ToString());
            //int idArea = int.Parse(area.id.ToString());

            DataCheck(area);

            DialogResult dialogresult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);

            if (dialogresult == DialogResult.Yes)
            {
                using (var db = new PUEntitiesOne())
                {
                    //bool educator = db.Educators.Any(x => x.areaId == area.id);
                    //bool courses = db.Courses.Any(x => x.areaId == area.id);

                    //if (educator || courses)
                    //{
                    //    MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
                    //    return;
                    //}

                    //db.DeleteArea(id);
                    db.Entry(area).State = System.Data.Entity.EntityState.Deleted;
                    db.Areas.Remove(area);

                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
                        return;
                        //MessageBox.Show(ex.ToString());
                    }
                    LoadData();
                }
            }
        }
Example #7
0
        private void simpleButtonContragent_Click(object sender, EventArgs e)
        {
            using (var db = new PUEntitiesOne())
            {
                if (textEditName.Text == null || textEditName.Text == "" || textEditEIK.Text == "" || textEditMOL.Text == "")
                {
                    MessageBox.Show("Полето трябва да е запълнено");
                    return;
                }

                if (isUpdate)
                {
                    var con = db.Contragets.FirstOrDefault(x => x.id == data.id);
                    con.name    = textEditName.Text;
                    con.address = textEditAddress.Text;
                    con.EIK     = textEditEIK.Text;
                    con.MOL     = textEditMOL.Text;
                }
                else
                {
                    Contraget con = new Contraget();
                    con.name    = textEditName.Text;
                    con.address = textEditAddress.Text;
                    con.EIK     = textEditEIK.Text;
                    con.MOL     = textEditMOL.Text;

                    db.Contragets.Add(con);
                }

                try
                {
                    db.SaveChanges();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }

                this.Hide();
            }
        }
        private void simpleButtonAddUpdate_Click(object sender, EventArgs e)
        {
            if (textEditEducatorName.Text == null || textEditEducatorName.Text == "" ||
                treeListLookUpEdit1.EditValue == null || treeListLookUpEditArea.EditValue == null)
            {
                MessageBox.Show("Въведете валидни данни");
                return;
            }


            using (var db = new PUEntitiesOne())
            {
                if (isUpdate)
                {
                    var edu = db.Educators.FirstOrDefault(x => x.id == data.id);
                    edu.educatorName = textEditEducatorName.Text;
                    edu.areaId       = int.Parse(treeListLookUpEditArea.EditValue.ToString());
                    edu.faculcyId    = int.Parse(treeListLookUpEdit1.EditValue.ToString());
                }
                else
                {
                    Educator edu = new Educator();

                    edu.educatorName = textEditEducatorName.Text;
                    edu.areaId       = int.Parse(treeListLookUpEditArea.EditValue.ToString());
                    edu.faculcyId    = int.Parse(treeListLookUpEdit1.EditValue.ToString());
                    db.Educators.Add(edu);
                }

                try
                {
                    db.SaveChanges();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }

                this.Hide();
            }
        }
        //public bool IsNumber(object value)
        //{
        //    return value is double
        //            || value is decimal;
        //}

        //public List<Data> Fill()
        //{
        //    //db.SaveChanges е закоментирано !!!!!!!!
        //    var listData = new List<Data>();



        //    foreach (var item in )
        //    {

        //        if (IsNumber(item))
        //        {
        //            //listData.Add(int.Parse(item.ToString()));
        //        }

        //    }

        //    return listData;
        //}

        private void simpleButtonAddUpdate_Click(object sender, EventArgs e)
        {
            //Трябва да се разкоментира и да се направи условие

            int      contractNum        = int.Parse(textEditContractNum.Text);
            DateTime contractDate       = textEditContractDate.DateTime;
            DateTime startDate          = dateEditStart.DateTime;
            DateTime endDate            = dateEditEnd.DateTime;
            decimal  priceWithCredit    = decimal.Parse(textEditWithCredit.EditValue.ToString());
            double   totalWihtCredit    = double.Parse(textEditTotalCredit.Text);
            double   priceWithoutCredit = double.Parse(textEditWithCredit.EditValue.ToString());
            double   totalWihtoutCredit = double.Parse(textEditTotalWithoutCredit.EditValue.ToString());
            double   totalSum           = double.Parse(textEditTotalOfContracts.EditValue.ToString());
            double   DDS               = double.Parse(textEditDDS.EditValue.ToString());
            double   DKPRPS            = double.Parse(textEditDKPRPS.EditValue.ToString());
            double   honorar           = double.Parse(textEditHonorar.EditValue.ToString());
            double   materialExprenses = double.Parse(textEditMaterialExpense.EditValue.ToString());



            if (contractNum == 0 || contractDate == DateTime.MinValue || treeListLookUpEditContragent.EditValue != "" ||
                treeListLookUpEditCourse.EditValue != "" || treeListLookUpEditEducator.EditValue != "" || startDate == DateTime.MinValue ||
                endDate == DateTime.MinValue)
            {
                MessageBox.Show("Трябва да въведете валидни данни");

                return;
            }
            using (var db = new PUEntitiesOne())
            {
                if (isUpdate)
                {
                    var row = db.Contracts.FirstOrDefault(x => x.id == contract.id);

                    row.contractNumber     = int.Parse(textEditContractNum.EditValue.ToString());
                    row.contractDate       = textEditContractDate.DateTime;
                    row.contragentId       = int.Parse(treeListLookUpEditContragent.EditValue.ToString());
                    row.courseId           = int.Parse(treeListLookUpEditCourse.EditValue.ToString());
                    row.educatorId         = int.Parse(treeListLookUpEditEducator.EditValue.ToString());
                    row.startDate          = dateEditStart.DateTime;
                    row.endDate            = dateEditEnd.DateTime;
                    row.priceWithCredit    = decimal.Parse(textEditWithCredit.EditValue.ToString());
                    row.totalWithCredit    = int.Parse(textEditTotalCredit.EditValue.ToString());
                    row.priceWithoutCredit = decimal.Parse(textEditWithoutCredit.EditValue.ToString());
                    row.totalWithoutCredit = int.Parse(textEditTotalWithoutCredit.EditValue.ToString());
                    row.sumOfContract      = int.Parse(textEditTotalOfContracts.EditValue.ToString());
                    row.DDS                 = int.Parse(textEditDDS.EditValue.ToString());
                    row.deductionsForPU     = int.Parse(textEditPU.EditValue.ToString());
                    row.deductionsForDKPRPS = int.Parse(textEditDKPRPS.EditValue.ToString());
                    row.remunerationFee     = int.Parse(textEditHonorar.EditValue.ToString());
                    row.materialCost        = int.Parse(textEditMaterialExpense.EditValue.ToString());
                }
                else
                {
                    Contract con = new Contract();

                    con.contractNumber     = int.Parse(textEditContractNum.EditValue.ToString());
                    con.contractDate       = textEditContractDate.DateTime;
                    con.contragentId       = int.Parse(treeListLookUpEditContragent.EditValue.ToString());
                    con.courseId           = int.Parse(treeListLookUpEditCourse.EditValue.ToString());
                    con.educatorId         = int.Parse(treeListLookUpEditEducator.EditValue.ToString());
                    con.startDate          = dateEditStart.DateTime;
                    con.endDate            = dateEditEnd.DateTime;
                    con.priceWithCredit    = decimal.Parse(textEditWithCredit.EditValue.ToString());
                    con.totalWithCredit    = int.Parse(textEditTotalCredit.EditValue.ToString());
                    con.priceWithoutCredit = decimal.Parse(textEditWithoutCredit.EditValue.ToString());
                    con.totalWithoutCredit = int.Parse(textEditTotalWithoutCredit.EditValue.ToString());
                    con.sumOfContract      = int.Parse(textEditTotalOfContracts.EditValue.ToString());
                    con.DDS                 = int.Parse(textEditDDS.EditValue.ToString());
                    con.deductionsForPU     = int.Parse(textEditPU.EditValue.ToString());
                    con.deductionsForDKPRPS = int.Parse(textEditDKPRPS.EditValue.ToString());
                    con.remunerationFee     = int.Parse(textEditHonorar.EditValue.ToString());
                    con.materialCost        = int.Parse(textEditMaterialExpense.EditValue.ToString());

                    db.Contracts.Add(con);
                }

                try
                {
                    db.SaveChanges();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }

                this.Hide();
            }
        }