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