Esempio n. 1
0
        public TSS_SurveyDocument SurveyBySiteSurveyId(Int64 SiteSurveyId)
        {
            var sur = new TSS_SurveyDocument();
            var sd  = new TSS_SectionDL();
            var dt  = sd.Get("By_SiteSurveyId_Only_Sections", SiteSurveyId.ToString());

            if (dt.Rows.Count == 0)
            {
                return(sur);
            }
            sur.SiteId      = int.Parse(dt.Rows[0]["SiteId"].ToString());
            sur.SiteCode    = dt.Rows[0]["SiteCode"].ToString();
            sur.WoRefId     = dt.Rows[0]["WoRefId"].ToString();
            sur.Status      = dt.Rows[0]["Status"].ToString();
            sur.ClientName  = dt.Rows[0]["ClientName"].ToString();
            sur.CityName    = dt.Rows[0]["CityName"].ToString();
            sur.Scope       = dt.Rows[0]["Scope"].ToString();
            sur.Category    = dt.Rows[0]["Category"].ToString();
            sur.SubCategory = dt.Rows[0]["SubCategory"].ToString();
            sur.Latitude    = dt.Rows[0]["Latitude"].ToString();
            sur.Longitude   = dt.Rows[0]["Longitude"].ToString();
            ;
            sur.SurveyId     = int.Parse(dt.Rows[0]["SurveyId"].ToString());
            sur.SiteSurveyId = int.Parse(dt.Rows[0]["SiteSurveyId"].ToString());
            sur.SurveyTitle  = dt.Rows[0]["SurveyTitle"].ToString();
            sur.Description  = dt.Rows[0]["Sur Descp"].ToString();
            var tempSections = dt.AsEnumerable()
                               .GroupBy(r => new { Col1 = r["SiteSectionId"] })
                               .Select(g => g.OrderBy(r => r["SiteSectionId"]).First())
                               .CopyToDataTable();

            sur.Sections = new TSS_SurveyDocumentBL().GetSections("SURVEY_SECTIONS_BY_SITESURVEYID", SiteSurveyId.ToString(), true);
            //sur.Sections = new TSS_SurveyDocumentBL().FillRecursive(sur.Sections, 0);
            return(sur);
        }
Esempio n. 2
0
        public TSS_SurveyDocument SurveyBySiteId(Int64 SiteSurveyId)
        {
            var sur = new TSS_SurveyDocument();
            var sd  = new TSS_SectionDL();
            var dt  = sd.Get("By_SiteSurveyId_Only_Sections", SiteSurveyId.ToString());

            if (dt.Rows.Count == 0)
            {
                return(sur);
            }
            sur.SiteId        = int.Parse(dt.Rows[0]["SiteId"].ToString());
            sur.SiteAddress   = dt.Rows[0]["SiteAddress"].ToString();
            sur.SiteCode      = dt.Rows[0]["SiteCode"].ToString();
            sur.WoRefId       = dt.Rows[0]["WoRefId"].ToString();
            sur.Status        = dt.Rows[0]["Status"].ToString();
            sur.ClientName    = dt.Rows[0]["ClientName"].ToString();
            sur.CityName      = dt.Rows[0]["CityName"].ToString();
            sur.Scope         = dt.Rows[0]["Scope"].ToString();
            sur.Category      = dt.Rows[0]["Category"].ToString();
            sur.SubCategory   = dt.Rows[0]["SubCategory"].ToString();
            sur.Latitude      = dt.Rows[0]["Latitude"].ToString();
            sur.Longitude     = dt.Rows[0]["Longitude"].ToString();
            sur.SurveyId      = int.Parse(dt.Rows[0]["SurveyId"].ToString());
            sur.SiteSurveyId  = int.Parse(dt.Rows[0]["SiteSurveyId"].ToString());
            sur.SurveyTitle   = dt.Rows[0]["SurveyTitle"].ToString();
            sur.Description   = dt.Rows[0]["Sur Descp"].ToString();
            sur.ProjectName   = dt.Rows[0]["ProjectName"].ToString();
            sur.WODescription = dt.Rows[0]["WODescription"].ToString();
            sur.SiteTpye      = dt.Rows[0]["SiteType"].ToString();
            var tempSections = dt.AsEnumerable()
                               .GroupBy(r => new { Col1 = r["SiteSectionId"] })
                               .Select(g => g.OrderBy(r => r["SiteSectionId"]).First())
                               .CopyToDataTable();

            sur.Sections = new TSS_SurveyDocumentBL().GetSections("SURVEY_SECTIONS_BY_SITESURVEYID",
                                                                  sur.SiteSurveyId.ToString(), true, 0, 0, true);

            sur.CompletetionSections = new TSS_SurveyDocumentBL().GetSections("SURVEY_SECTIONS_BY_SITESURVEYID_FOR_COMPLETION",
                                                                              sur.SiteSurveyId.ToString(), true, 0, 0, true);
            sur.SiteAttendeesList  = new TSS_DashboardBL().GetSiteAttendees("Get_Site_Attendees_For_Dashboard", Convert.ToInt32(sur.SiteId), Convert.ToInt32(sur.SiteSurveyId));
            sur.SectorLocationList = new TSS_SurveyDocumentBL().GetSectorLocations(Convert.ToInt64(sur.SiteSurveyId));
            //foreach (var q in sur.Sections)
            //{
            //    if (q.IsRepeatable) continue;
            //    var que = new TSS_QuestionBL().GetQuestionsWithOptions("GET_Questions_BY_SECTIONID_API", 0, q.SiteSectionId.ToString(), true);
            //    if (que.Any())
            //        q.Questions.AddRange(que);
            //}

            ////sur.Sections = sur.Sections.OrderBy(s => s.PSectionId).ThenBy(s => s.SiteSectionId).ToList();
            //sur.Sections = new TSS_SurveyDocumentBL().FillChildRecursive(sur.Sections, 0);
            return(sur);
        }
Esempio n. 3
0
 public void GenerateChildSections()
 {
     var result = new TSS_SectionDL().GenerateChildSections("GENERATE_CHILD_SITE_SECTIONS", 70131, 2).ToList <TSS_Section>();
 }
Esempio n. 4
0
        public TSS_SurveyDocument SurvayBySite(Int64 SiteSurveyId)
        {
            TSS_SurveyDocument sur = new TSS_SurveyDocument();
            TSS_SectionBL      sb  = new TSS_SectionBL();
            //----------------------------------------

            //var result = myList.GroupBy(test => test.id)
            //.Select(grp => grp.First())
            //.ToList();

            TSS_SectionDL sd = new TSS_SectionDL();
            DataTable     dt = sd.Get("By_SiteSurveyId", SiteSurveyId.ToString());

            if (dt.Rows.Count != 0)
            {
                foreach (DataRow item in dt.Rows)
                {
                    sur.SiteId     = int.Parse(dt.Rows[0]["SiteId"].ToString());
                    sur.SiteCode   = dt.Rows[0]["SiteCode"].ToString();
                    sur.WoRefId    = dt.Rows[0]["WoRefId"].ToString();
                    sur.Status     = dt.Rows[0]["Status"].ToString();
                    sur.ClientName = dt.Rows[0]["ClientName"].ToString();

                    sur.CityName = dt.Rows[0]["CityName"].ToString();
                    sur.Scope    = dt.Rows[0]["Scope"].ToString();

                    sur.Category    = dt.Rows[0]["Category"].ToString();
                    sur.SubCategory = dt.Rows[0]["SubCategory"].ToString();

                    sur.Latitude  = dt.Rows[0]["Latitude"].ToString();
                    sur.Longitude = dt.Rows[0]["Longitude"].ToString();

                    sur.SurveyId     = int.Parse(dt.Rows[0]["SurveyId"].ToString());
                    sur.SiteSurveyId = int.Parse(dt.Rows[0]["SiteSurveyId"].ToString());

                    sur.SurveyTitle = dt.Rows[0]["SurveyTitle"].ToString();
                    sur.Description = dt.Rows[0]["Sur Descp"].ToString();
                    break;
                }


                var temp = dt.AsEnumerable()
                           .GroupBy(r => new { Col1 = r["SiteSectionId"] })
                           .Select(g => g.OrderBy(r => r["SiteSectionId"]).First())
                           .CopyToDataTable();

                List <TSS_Section> sec = temp.ToList <TSS_Section>();
                TSS_QuestionBL     qb  = new TSS_QuestionBL();

                foreach (var q in sec)
                {
                    var que = qb.ToList("GET_QUESTION_BY_SECTION", q.SiteSectionId.ToString());
                    if (que != null)
                    {
                        q.Questions.AddRange(que);
                    }

                    TSS_ResponseBL    rb   = new TSS_ResponseBL();
                    RequiredActionsBL reqA = new RequiredActionsBL();

                    foreach (var r in que)
                    {
                        var resp = rb.ToList("GET_RESPONSE_BY_SITEQUESTION", r.QuestionId.ToString());
                        if (resp != null)
                        {
                            r.Responses.AddRange(resp);
                        }
                    }

                    foreach (var r in que)
                    {
                        var rAction = reqA.ToList("GET_REQACTION_BY_SITEQUESTION", r.QuestionId.ToString());
                        if (rAction != null)
                        {
                            r.ReqActions.AddRange(rAction);
                        }
                    }
                }

                sur.Sections = sec;


                //var temp = dt.AsEnumerable()
                //                  .GroupBy(r => new { Col1 = r["SiteSectionId"] })
                //                  .Select(g => g.OrderBy(r => r["SiteSectionId"]).First())
                //                  .CopyToDataTable();
                //List<TSS_Section> sec = temp.ToList<TSS_Section>();

                //foreach (var item in sec)
                //{
                //    dt.DefaultView.RowFilter = "SiteSectionId='" + item.SiteSectionId + "'";
                //    DataTable ques = (dt.DefaultView).ToTable();
                //    item.Questions = ques.ToList<TSS_Question>();

                //    foreach (var res in item.Questions)
                //    {
                //        dt.DefaultView.RowFilter = "QuestionId='" + res.QuestionId + "'";
                //        DataTable quesLogic = (dt.DefaultView).ToTable();
                //        res.QuestionLogics = quesLogic.ToList<TSS_QuestionLogic>();


                //        dt.DefaultView.RowFilter = "QuestionId='" + res.QuestionId + "'";
                //        DataTable response = (dt.DefaultView).ToTable();
                //        res.Responses = response.ToList<TSS_Response>();

                //        dt.DefaultView.RowFilter = "SiteQuestionId='" + res.QuestionId + "'";
                //        DataTable reqAction = (dt.DefaultView).ToTable();
                //        res.ReqActions = reqAction.ToList<RequiredActions>();
                //    }
                //}
                //sur.Sections = sec;

                //-------------------------------
            }
            return(sur);
        }