Esempio n. 1
0
        public Response SurveyAction(List <TSS_SurveyAction> action)
        {
            Response r = new Response();

            try
            {
                TSS_SurveyResponseDL srd = new TSS_SurveyResponseDL();

                dbDataTable dbdt = new dbDataTable();
                DataTable   dt   = dbdt.Survey_List();

                foreach (var res in action)
                {
                    var NewAzimuth     = res.Azimuth;
                    var NewAltitude    = res.Altitude;
                    var NewGPSAccuracy = res.GPSAccuracy;
                    if (NewAzimuth != "")
                    {
                        NewAzimuth = Math.Round(Convert.ToDecimal(NewAzimuth), 2).ToString();
                    }
                    if (NewAltitude != "")
                    {
                        NewAltitude = Math.Round(Convert.ToDecimal(res.Altitude), 2).ToString();
                    }
                    if (NewGPSAccuracy != "")
                    {
                        NewGPSAccuracy = Math.Round(Convert.ToDecimal(res.GPSAccuracy), 2).ToString();
                    }

                    myDataTable.AddRow(dt, "Value1", res.SiteId,
                                       "Value2", res.SurveyId,
                                       "Value3", res.SectionId,
                                       "Value4", res.QuestionId,
                                       "Value5", res.ActionType,
                                       "Value6", res.Remarks,
                                       "Value7", res.IterationId,
                                       "Value8", res.PIterationId,
                                       "Value9", res.Latitude,
                                       "Value10", res.Longitude,
                                       "Value11", NewAzimuth,
                                       "Value12", res.ObjectView,
                                       "Value13", NewAltitude,
                                       "Value14", NewGPSAccuracy,
                                       "Value15", res.ActionValue);
                }


                srd.Manage("SurveyAction", dt);
                r.Status  = "success";
                r.Message = "success";
            }
            catch (Exception ex)
            {
                r.Status  = "error";
                r.Message = ex.Message;
            }

            return(r);
        }
Esempio n. 2
0
        public Response SurveyResponse(List <TSS_SurveyResponse> response)
        {
            Response r = new Response();

            try
            {
                TSS_SurveyResponseDL srd = new TSS_SurveyResponseDL();

                dbDataTable dbdt = new dbDataTable();
                DataTable   dt   = dbdt.Survey_List();
                foreach (var res in response)
                {
                    string ImageBase = "";
                    if (!res.IsSectorLocation)
                    {
                        if (res.QuestionType == "Direction & GPS Based Images")
                        {
                            if (res.ResponseValue != "" && res.ResponseValue != null)
                            {
                                ImageBase = ConvertImageURLToBase64(res.ResponseValue, res.MapZoom);
                            }
                        }
                    }
                    else
                    {
                        ImageBase = GetLineMap(res.ResponseValue, res.MapZoom, res.Azimuth);
                    }
                    myDataTable.AddRow(dt, "Value1", res.SiteId, "Value2", res.SurveyId, "Value3", res.SectionId, "Value4", res.QuestionId, "Value5", res.ResponseId, "Value6", res.IterationId, "Value7", res.ResponseText, "Value8", res.pIterationId, "Value9", res.MinValue, "Value10", res.MaxValue, "Value11", res.IsGps, "Value12", res.ResponseValue, "Value13", res.MapZoom, "Value14", ImageBase, "Value15", res.Signature, "Value16", res.Azimuth);
                }
                srd.Manage("SurveyResponse", dt);
                r.Status  = "success";
                r.Message = "success";
            }
            catch (Exception ex)
            {
                r.Status  = "error";
                r.Message = ex.Message;
            }

            return(r);
        }
Esempio n. 3
0
 public Response UpdateSectionStatus(Int64 sectionId, int status)
 {
     try
     {
         DataTable result = new TSS_SurveyResponseDL().UpdateSectionStatus(sectionId, status);
         return(new Response()
         {
             Message = result.Rows[0][0].ToString(),
             Status = "200",
             Value = true
         });
     }
     catch (Exception ex)
     {
         return(new Response()
         {
             Message = ex.Message,
             Status = "400",
             Value = false
         });
     }
 }