Esempio n. 1
0
        public view_expertise_pospelov GetListExpertisePospelov(int id_expertise, int id_expert)
        {
            try
            {
                view_expertise_pospelov result = new view_expertise_pospelov();
                expertises _expertises         = db_Expertises.expertises.Where(p => p.id_expertise == id_expertise).FirstOrDefault();
                if (_expertises != null)
                {
                    List <factors>       list_pr_ex         = db_Expertises.factors.Where(p => p.id_expertise == id_expertise).ToList();
                    List <marks_ribs>    list_marks_ribs    = db_Expertises.marks_ribs.Where(p => p.id_expertise == id_expertise && p.id_expert == id_expert).ToList();
                    List <marks_factors> list_marks_factors = db_Expertises.marks_factors.Where(p => p.id_expertise == id_expertise && p.id_expert == id_expert).ToList();
                    List <factors>       temp  = new List <factors>();
                    List <ribs>          temp2 = new List <ribs>();
                    foreach (var pr in list_pr_ex)
                    {
                        factors t = new factors();
                        t.id_expertise = pr.id_expertise;
                        t.id_factor    = pr.id_factor;
                        t.priority     = pr.priority;
                        t.name         = pr.name;
                        List <ribs> list_ex_cr = db_Expertises.ribs.Where(p => p.id_factor_from == pr.id_factor).ToList();
                        if (list_ex_cr != null)
                        {
                            foreach (var pr2 in list_ex_cr)
                            {
                                ribs t2 = new ribs();
                                t2.id_rib         = pr2.id_rib;
                                t2.id_factor_from = pr2.id_factor_from;
                                t2.id_factor_in   = pr2.id_factor_in;
                                temp2.Add(t2);
                            }
                        }
                        temp.Add(t);
                    }


                    List <marks_factors> temp3 = new List <marks_factors>();
                    foreach (var pr in list_marks_factors)
                    {
                        marks_factors t = new marks_factors();
                        t.id_mark      = pr.id_mark;
                        t.id_expertise = pr.id_expertise;
                        t.id_factor    = pr.id_factor;
                        t.id_expert    = pr.id_expert;
                        t.value        = pr.value;
                        temp3.Add(t);
                    }
                    List <marks_ribs> temp4 = new List <marks_ribs>();
                    foreach (var pr in list_marks_ribs)
                    {
                        marks_ribs t = new marks_ribs();
                        t.id_mark_rib  = pr.id_mark_rib;
                        t.id_expertise = pr.id_expertise;
                        t.id_rib       = pr.id_rib;
                        t.id_expert    = pr.id_expert;
                        t.value        = pr.value;
                        temp4.Add(t);
                    }
                    result.id_expertise       = id_expertise;
                    result.list_factors       = temp;
                    result.list_ribs          = temp2;
                    result.list_marks_factors = temp3;
                    result.list_marks_ribs    = temp4;

                    //return _expertises.id_expertise;
                }
                return(result);
            }
            catch (Exception Ex)
            {
                // тут логируется ошибка
                view_expertise_pospelov tmpC = new view_expertise_pospelov();
                tmpC.id_expertise = -1;


                return(tmpC);
            }
        }
Esempio n. 2
0
        //Метод добавления экспертизы pospelov
        public int AddExperisePospelov(string name, List <int> ls_id_experts, List <List <string> > ls_fac /*List<int> ls_prior, List<string> ls_name_fact*/)
        {
            try
            {
                expertises _expertises = new expertises();
                _expertises.name      = name;
                _expertises.id_status = 1;
                _expertises.type      = 2;
                db_Expertises.expertises.Add(_expertises);
                db_Expertises.SaveChanges();


                foreach (int temp in ls_id_experts)
                {
                    experts_expertises ex_ex = new experts_expertises();
                    ex_ex.id_expertise = _expertises.id_expertise;
                    ex_ex.id_expert    = temp;
                    ex_ex.id_status    = 1;
                    db_Expertises.experts_expertises.Add(ex_ex);
                    db_Expertises.SaveChanges();
                }
                int level = 0;
                foreach (var temp in ls_fac)
                {
                    for (int i = 0; i < temp.Count(); i++)
                    {
                        factors fc = new factors();
                        fc.id_expertise = _expertises.id_expertise;
                        fc.name         = temp[i];
                        fc.priority     = level;
                        db_Expertises.factors.Add(fc);
                        db_Expertises.SaveChanges();
                    }
                    level++;
                }
                int max_priority = ls_fac.Count();
                level = 0;
                foreach (var temp in ls_fac)
                {
                    if (level != max_priority)
                    {
                        for (int i = 0; i < temp.Count(); i++)
                        {
                            string name_fact = temp[i];
                            var    id_factor = db_Expertises.factors.Where(o => o.id_expertise == _expertises.id_expertise && o.name == name_fact).FirstOrDefault().id_factor;

                            List <factors> tmpFactors = db_Expertises.factors.Where(o => o.priority == level + 1 && o.id_expertise == _expertises.id_expertise).ToList();
                            foreach (var fact in tmpFactors)
                            {
                                ribs r = new ribs();
                                r.id_factor_from = id_factor;
                                r.id_factor_in   = fact.id_factor;
                                db_Expertises.ribs.Add(r);
                                db_Expertises.SaveChanges();
                            }
                        }
                        level++;
                    }
                }
                return(_expertises.id_expertise);
            }
            catch (Exception ex)
            {
                return(-1);
            }
        }