public void InserCity()
{
string sql2 = SQLHelper.AddCity("San Francisco", "SAD", "Very nice city");
SQLHelper.ExecuteCommand(sql2);
sql2 = SQLHelper.AddCity("Toronto", "SAD", "City of night life");
SQLHelper.ExecuteCommand(sql2);
}
public void InsertUsers()
{
string sql = SQLHelper.GetSqlCommand("srdjan", "tomic", "admin", "pass", "saltt", "hash", "admin");
SQLHelper.ExecuteCommand(sql);
string sql1 = SQLHelper.GetSqlCommand("srdjan", "topic", "user", "pass", "saltt", "hash", "regular");
SQLHelper.ExecuteCommand(sql1);
}
public void InserCity()
{
string sql2 = SQLHelper.AddCity("San Francisco", "Serbia", "Very nice city");
SQLHelper.ExecuteCommand(sql2);
sql2 = SQLHelper.AddCity("Toronto", "Serbia", "City of night life");
SQLHelper.ExecuteCommand(sql2);
sql2 = SQLHelper.AddCity("Moscow", "France", "City of lights");
SQLHelper.ExecuteCommand(sql2);
sql2 = SQLHelper.AddCity("Las Vegas", "France", "City of lights");
SQLHelper.ExecuteCommand(sql2);
sql2 = SQLHelper.AddCity("Los Angeles", "France", "City of lights");
SQLHelper.ExecuteCommand(sql2);
}
public void InsertUsers()
{
string sql = SQLHelper.GetSqlCommand("gocii", "pavee", "admin", "pass", "saltt", "hashhh", "admin");
SQLHelper.ExecuteCommand(sql);
string sql1 = SQLHelper.GetSqlCommand("gocii", "pavee", "user1", "pass", "saltt", "hashhh", "regular");
SQLHelper.ExecuteCommand(sql1);
string sql2 = SQLHelper.GetSqlCommand("gocii", "pavee", "user2", "pass", "saltt", "hashhh", "regular");
SQLHelper.ExecuteCommand(sql2);
string sql3 = SQLHelper.GetSqlCommand("gocii", "pavee", "user3", "pass", "saltt", "hashhh", "regular");
SQLHelper.ExecuteCommand(sql3);
string sql4 = SQLHelper.GetSqlCommand("gocii", "pavee", "goci", "pass", "saltt", "hashhh", "admin");
SQLHelper.ExecuteCommand(sql4);
}
public void InsertRoutes(string airportID, string airname, string aircity, string aircountry, string airIATA, string airICAO, string airlatitude, string airlongitude, string airaltitude, string airtimezone) //potrebna izmena naziva
{
string sql = SQLHelper.InsertRout(airportID, Guid.NewGuid().ToString(), aircity, aircountry, airIATA, airICAO, airlatitude, airlongitude, airaltitude, airtimezone);
SQLHelper.ExecuteCommand(sql);
}
public void InsertUsers(string first, string last, string username, string pass, string salt)
{
string sql = SQLHelper.GetSqlCommand(first, last, username, pass, "saltt", "hashhh", "regular");
SQLHelper.ExecuteCommand(sql);
}
public void InserCity(string cityname, string countryname, string descript)
{
string sql = SQLHelper.AddCity(cityname, countryname, descript);
SQLHelper.ExecuteCommand(sql);
}
public void Delete(string id, string user)
{
string sql = Comment.DeleteComm(id, user);
SQLHelper.ExecuteCommand(sql);
}
public void Update(string id, string comment, DateTime a)
{
string sql = Comment.UpdateComm(id, comment, a);
SQLHelper.ExecuteCommand(sql);
}
public void InsertComment(string id, string city, string coment, string user)
{
string sql = SQLHelper.AddComment(id, city, coment, user, DateTime.Now, DateTime.Now);
SQLHelper.ExecuteCommand(sql);
}
public void InsertComment()
{
string sql = SQLHelper.AddComment(Guid.NewGuid().ToString(), "West Sale Airport", "Prvi komentar", "user1", DateTime.Now, DateTime.Now);
SQLHelper.ExecuteCommand(sql);
}
public void InsertAirs(string airportID, string airname, string aircity, string aircountry, string airIATA, string airICAO, string airlatitude, string airlongitude, string airaltitude, string airtimezone, string airdst, string airdbtimezone, string airtype, string airsource) //potrebna dorada
{
string sql = SQLHelper.InsertAirs(airportID, airname, aircity, aircountry, airIATA, airICAO, airlatitude, airlongitude, airaltitude, airtimezone, airdst, airdbtimezone, airtype, airsource);
SQLHelper.ExecuteCommand(sql);
}