public RoadSegmentsViewModel(List<Segment> segs, Road road)
{
Segments = segs;
this.road = road;
}
public static void EditRoad(Road road)
{
if (sqlConnection.State == ConnectionState.Closed) sqlConnection.Open();
object sql_result;
string fro = @"""From""";
string to = @"""To""";
string command_text = "update " + databaseName + ".roads SET Name='" + road.Name + "', District='" + road.District + "', "+fro+" = '" + road.From + "',"+ to+"='" + road.To
+ "', FunctionalClass='" + road.FunctionalClass + "',SurfaceType='" + road.SurfaceType + "',Remarks='" + road.Remarks + "',isDeleted='" + road.isDeleted+ "' WHERE Id = '" + road.Id + "'";
SqlCommand command = new SqlCommand(command_text, sqlConnection);
try
{
sql_result = command.ExecuteReader();
var re = sql_result;
sqlConnection.Close();
}
catch(Exception e)
{
e.ToString();
}
}
public RoadSegmentsViewModel()
{
Segments = null;
road = null;
}
public static void DeleteRoad(Road road)
{
//This works fine, but need to add a delete flag as soft delete
//try
//{
// DeletePhotoesByRoadID(road.Id);
// DeleteSurveysByRoadID(road.Id);
// DeleteRoadSurveysByRoadId(road.Id);
// DeleteSegmentByRoadID(road.Id);
// if (sqlConnection.State == ConnectionState.Closed) sqlConnection.Open();
// SqlCommand command_deleteRoad = new SqlCommand("DELETE FROM " + databaseName + ".roads where Id='" + road.Id + "'", sqlConnection);
// try
// {
// var sql_result = command_deleteRoad.ExecuteReader();
// sqlConnection.Close();
// }
// catch (Exception e)
// {
// e.ToString();
// }
//} catch (Exception e2)
//{
// e2.ToString();
//}
try
{
// Survey will be really deleted
DeletePhotoesByRoadID(road.Id);
DeleteSurveysByRoadID(road.Id);
markRoadSurveyAsDeleted(road.Id);
markSegmentAsDeleted(road.Id);
if (sqlConnection.State == ConnectionState.Closed) sqlConnection.Open();
SqlCommand command_markRoadAsDeleted = new SqlCommand("UPDATE " + databaseName + ".roads SET isDeleted='True' WHERE Id='" + road.Id + "'", sqlConnection);
try
{
var sql_result = command_markRoadAsDeleted.ExecuteReader();
sqlConnection.Close();
}
catch (Exception e)
{
e.ToString();
}
}
catch (Exception e)
{
e.ToString();
}
}
public static void EditRoad(Road road)
{
// use SQL update command
try
{
DataTools.EditRoad(road);
}
catch (System.Net.WebException ex)
{
Console.WriteLine(ex.ToString());
Console.ReadLine();
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Read();
}
}
public static async Task<List<Segment>> GetSegmentsByRoad(Road road)
{
if (road.Id == null) return null;
var url = String.Format("tables/segment?$filter=roadId eq '{0}'", road.Id);
return JsonConvert.DeserializeObject<List<Segment>>(await Client.GetAsyncWithCred(url));
}
public static async Task<List<RoadSurvey>> GetRoadSurveysByRoad(Road road)
{
if (road.Id == null) return null;
var url = String.Format("tables/roadsurvey?$filter=roadId eq {0}", road.Id);
var roadsurveys = await Client.GetAsyncWithCred(url);
return JsonConvert.DeserializeObject<List<RoadSurvey>>(roadsurveys);
}
public static async Task CreateRoad(Road road)
{
try
{
string theUri = BaseURL + "tables/road";
//Create a Json Serializer for our type
String jsonSer = JsonConvert.SerializeObject(road);
HttpContent payload = new StringContent(jsonSer, System.Text.Encoding.UTF8, "application/json");
//Post the data
var aResponse = await Client.PostAsync(theUri, payload);
}
catch (System.Net.WebException ex)
{
Console.WriteLine(ex.ToString());
Console.ReadLine();
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Read();
}
}
