public void deleteStationById(int sid)
{
string sql = "exec delstation @sid";
SqlParameter pSid = new SqlParameter("@sid", sid);
db.ExecuteUpdate(sql, pSid);
}
public void addRoute(string name, string first, string last, int price)
{
string sql = "insert into route(name,first,last,price) values (@name,@first,@last,@price)";
SqlParameter pNname = new SqlParameter("@name", name);
SqlParameter pFirst = new SqlParameter("@first", first);
SqlParameter pLast = new SqlParameter("@last", last);
SqlParameter pPrice = new SqlParameter("@price", price);
db.ExecuteUpdate(sql, pNname, pFirst, pLast, pPrice);
}