internal bool UploadNew(DbPoint newOne, out int webId, out string msg) { try { BedekSurveyWebService.SurveyServiceSoapClient client = new BedekSurveyWebService.SurveyServiceSoapClient(); BedekSurveyWebService.ArrayOfAnyType values = new BedekSurveyWebService.ArrayOfAnyType(); values.Add(newOne.LevelID); values.Add(newOne.FieldID); values.Add(newOne.ClassID); values.Add(newOne.Number); values.Add(newOne.Info); values.Add(newOne.Time); values.Add(newOne.X); values.Add(newOne.Y); values.Add(newOne.Z); return(client.InsertNewMeasurements(values, out webId, out msg)); } catch (Exception e) { msg = e.Message; webId = -1; return(false); } }
public bool SaveNewPoint(DbPoint pt, out bool webidExists, out bool nameExists, out string errorMsg) { if (lda.InsertPoint(pt, out webidExists, out nameExists, out errorMsg)) { actPrompt?.Invoke("נקודה מס' " + pt.Number + " נשמרה בהצלחה"); return(true); } else { return(false); } }
public bool GetLocalNewsList(out DbPoint[] news, out string msg) { try { return(lda.GetNews(out news, out msg)); //Get all point where StatusID=-1 } catch (Exception e) { news = new DbPoint[0]; msg = e.Message; return(false); } }
internal bool GetNewMeasurements(DateTime fromDate, out DbPoint[] news, out string msg) { string errorMsg = ""; List <DbPoint> points = new List <DbPoint>(); try { BedekSurveyWebService.ArrayOfInt ids; BedekSurveyWebService.ArrayOfAnyType s_new; BedekSurveyWebService.SurveyServiceSoapClient client = new BedekSurveyWebService.SurveyServiceSoapClient(); //קבל את רשימת החדשות if (!client.GetAllNewMeasurements(fromDate, out ids, out msg)) { throw new Exception("WebService Error Getting IDs:\n" + msg); } //עבור כל נקודה ברשימה, קבל את פרטיה מהשרת foreach (int id in ids) { if (!client.GetMeasurement(id, out s_new)) { errorMsg += id.ToString() + "; "; } points.Add(new DbPoint(s_new.ToArray())); } news = points.ToArray(); if (errorMsg != "") { msg = "These points failed to be downloaded: IDs " + errorMsg; return(false); } msg = ""; return(true); } catch (Exception e) { msg = e.Message; news = new DbPoint[0]; return(false); } }
internal bool InsertPoint(DbPoint pt, out bool webidExists, out bool nameExists, out string msg) { webidExists = false; nameExists = false; try { SqlCommands.Insert.Point insert = new SqlCommands.Insert.Point(this.sql.sqlConn); insert.Command.Parameters[0].Value = pt.LevelID; insert.Command.Parameters[1].Value = pt.FieldID; insert.Command.Parameters[2].Value = pt.ClassID; insert.Command.Parameters[3].Value = pt.Number; insert.Command.Parameters[4].Value = pt.Info; insert.Command.Parameters[5].Value = pt.Time; insert.Command.Parameters[6].Value = pt.X; insert.Command.Parameters[7].Value = pt.Y; insert.Command.Parameters[8].Value = pt.Z; insert.Command.Parameters[9].Value = pt.StatusID; insert.Command.Parameters[10].Value = pt.WebID; this.sql.sqlConn.Open(); pt.ID = (int)insert.Command.ExecuteScalar(); msg = "OK"; return(true); } catch (Exception e) { if (e.Message.Contains("Unique_WebID")) { webidExists = true; } if (e.Message.Contains("Unique_Name")) { nameExists = true; } msg = e.Message; Console.WriteLine("error saving point: " + e.Message); return(false); } finally { this.sql.sqlConn.Close(); } }
internal bool GetNews(out DbPoint[] news, out string msg) { try { SqlCommands.Select.News select = new SqlCommands.Select.News(this.sql.sqlConn); this.sql.sqlConn.Open(); news = select.GetNews(); msg = ""; return(true); } catch (Exception e) { news = new DbPoint[0]; msg = e.Message; return(false); } finally { this.sql.sqlConn.Close(); } }
internal bool GetFieldPoints(int fieldId, out DbPoint[] points) { try { SqlCommands.Select.PointByField select = new SqlCommands.Select.PointByField(this.sql.sqlConn); select.Command.Parameters[0].Value = fieldId; this.sql.sqlConn.Open(); points = select.GetPoints(); return(true); } catch (Exception e) { points = new DbPoint[0]; this.msg = e.Message; return(false); } finally { this.sql.sqlConn.Close(); } }
internal bool GetLevelPointByClass(int levelId, int classId, out DbPoint[] points) { try { SqlCommands.Select.PointByClass select = new SqlCommands.Select.PointByClass(this.sql.sqlConn); select.Command.Parameters[0].Value = levelId; select.Command.Parameters[0].Value = classId; this.sql.sqlConn.Open(); points = select.GetPoints(); return(true); } catch (Exception e) { points = new DbPoint[0]; this.msg = e.Message; return(false); } finally { this.sql.sqlConn.Close(); } }