public List <VerticalCurve> GetAllVerticalCurves(bool isSource)
{
IEnumerable <dynamic> verticalCurves = null;
if (isSource)
{
verticalCurves = new VerticalCurvesSource().All();
}
else
{
verticalCurves = new VerticalCurves().All();
}
return(verticalCurves.Select(x => new VerticalCurve(x)).ToList());
}
public void DeleteVerticalCurve(VerticalCurve curve)
{
var sql = "DELETE FROM VerticalCurves WHERE ROUTE = @0 AND FROMMEAS = @1 AND TOMEAS = @2";
var args = new List <object>();
args.Add(curve.ROUTE);
args.Add(curve.FROMMEAS);
args.Add(curve.TOMEAS);
var table = new VerticalCurves();
table.Execute(sql, args: args.ToArray());
var str = string.Format("DELETED ROUTE: {0}, FROMMEAS: {1}, TOMEAS: {2}", curve.ROUTE, curve.FROMMEAS, curve.TOMEAS);
Console.WriteLine(str);
}
public List <VerticalCurve> GetVerticalCurvesByRoute(string route, bool isSource)
{
IEnumerable <dynamic> verticalCurves = null;
var args = new List <object>();
args.Add(route);
if (isSource)
{
verticalCurves = new VerticalCurvesSource().All(where : "ROUTE = @0", args: args.ToArray());
}
else
{
verticalCurves = new VerticalCurves().All(where : "ROUTE = @0", args: args.ToArray());
}
return(verticalCurves.Select(x => new VerticalCurve(x)).ToList());
}
public void UpdateVerticalCurve(VerticalCurve source, VerticalCurve toUpdate)
{
var query = "UPDATE VerticalCurves SET FROMMEAS = @0, TOMEAS = @1, DISTANCE = @2, PERCENTGRA = @3, VAFT = @4 WHERE ROUTE = @5 AND FROMMEAS = @6 AND TOMEAS = @7";
var args = new List <object>();
args.Add(toUpdate.FROMMEAS); // 0
args.Add(toUpdate.TOMEAS); // 1
args.Add(toUpdate.DISTANCE); // 2
args.Add(toUpdate.PERCENTGRA); // 3
args.Add(toUpdate.VAFT); // 4
args.Add(source.ROUTE); // 5
args.Add(source.FROMMEAS); // 6
args.Add(source.TOMEAS); // 7
var table = new VerticalCurves();
table.Execute(query, args: args.ToArray());
var str = string.Format("RowCount: {0}, UPDATED ROUTE: {1}, FROMMEAS: {2}, TOMEAS: {3}, VAFT: {4}", rowCount = rowCount + 1, toUpdate.ROUTE, toUpdate.FROMMEAS, toUpdate.TOMEAS, toUpdate.VAFT);
Console.WriteLine(str);
}
public void TruncateVerticalCurves()
{
var query = "TRUNCATE TABLE VerticalCurves";
var table = new VerticalCurves().Execute(query);
}
