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); }
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); }
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 }); } }