public static void DeleteSegment(Segment segment)
{
if (sqlConnection.State == ConnectionState.Closed) sqlConnection.Open();
//SqlCommand command = new SqlCommand("Delete from " + databaseName + ".segmentsurveys where SequenceId='" + segment.SequenceId + "' and roadid='" + segment.RoadId + "'", sqlConnection);
//try
//{
// var result = command.ExecuteReaderAsync();
// sqlConnection.Close();
//}
//catch (Exception ex)
//{
// ex.ToString();
//}
//if (sqlConnection.State == ConnectionState.Closed) sqlConnection.Open();
//SqlCommand command_deleteSegments = new SqlCommand("DELETE FROM " + databaseName + ".segments where InventId='" + segment.InventId + "'", sqlConnection);
//try
//{
// var sql_result = command_deleteSegments.ExecuteReader();
// sqlConnection.Close();
//}
//catch (Exception e)
//{
// e.ToString();
//}
DeleteSurveysByInventId(segment.InventId);
segment.isDeleted = true;
EditSegment(segment);
}
public async Task<ViewResult> Create(string RoadId)
{
Segment seg = new Segment();
var curUser = UserManager.FindById(User.Identity.GetUserId());
seg.RoadId = RoadId;
ViewBag.placeName = curUser.PlaceName;
var _road= await ApiHelper.GetRoadById(RoadId);
ViewBag.roadName = _road.Name;
return View(seg);
}
public async Task TestGetSegmentSurveysBySegment()
{
var segment = new Segment() {InventId = 77};
var hist = await ApiHelper.GetSegmentSurveysBySegment(segment);
Assert.IsNotNull(hist);
}
public static void EditSegment(Segment segment)
{
if (sqlConnection.State == ConnectionState.Closed) sqlConnection.Open();
object sql_result;
string fro = @"""From""";
string to = @"""To""";
string command_text = "update " + databaseName + ".segments SET sequenceId = '" + segment.SequenceId + "'," + fro + "='" + segment.From + "'," + to + "='" + segment.To + "',hasCurbOrGutter='" + segment.HasCurbOrGutter + "',remarks='" + segment.Remarks + "', inventId='" + segment.InventId + "', isdeleted='" + segment.isDeleted + "' WHERE inventId='" + segment.InventId + "'";
SqlCommand command = new SqlCommand(command_text, sqlConnection);
try
{
sql_result = command.ExecuteReader();
var re = sql_result;
sqlConnection.Close();
} catch (Exception e)
{
e.ToString();
}
}
public SegmentSurveyViewModel(List<SegmentSurvey> Surys, Segment Seg)
{
SegmentSurveys = Surys;
Segment = Seg;
}
public static async Task<List<SegmentSurvey>> GetSegmentSurveysBySegment(Segment segment)
{
var url = String.Format("tables/segmentsurvey?$filter=inventId eq {0}", segment.InventId);
var response = await Client.GetAsyncWithCred(url);
return (JsonConvert.DeserializeObject<List<SegmentSurvey>>(response)).OrderBy(ss => ss.SegSurveyDate).ToList();
}
public static async Task CreateSegment(Segment segment)
{
try
{
string theUri = BaseURL + "tables/segment";
String jsonSer = JsonConvert.SerializeObject(segment);
HttpContent payload = new StringContent(jsonSer, System.Text.Encoding.UTF8, "application/json");
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();
}
}
//public static Task DeleteSegmentSurveyByID(string id)
//{
// //try
// //{
// // var url = BaseURL + String.Format("tables/segmentsurvey/{0}", id);
// // var aResponse = await Client.DeleteAsync(url);
// // var result = aResponse;
// //}
// //catch (Exception ex)
// //{
// // var errorMessage = ex.ToString();
// //}
// DataTools.DeleteSurveyByID(id);
//}
public static void EditSegment(Segment segment)
{
try
{
DataTools.EditSegment(segment);
}
catch (System.Net.WebException ex)
{
Console.WriteLine(ex.ToString());
Console.ReadLine();
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Read();
}
}
