public static bool DeleteCity(string cityID)
{
string sql = "DELETE Cities WHERE CityID = @id";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@id", cityID);
return(DAO.ExecuteCommand(cmd));
}
/// <summary>
/// Delete User by Admin
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static bool DeleteUser(string email)
{
string sql = " DELETE USERS" +
" WHERE Email = @email";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@email", email);
return(DAO.ExecuteCommand(cmd));
}
public static bool addRoute(Route route)
{
string sql = "INSERT INTO [ROUTES] VALUES(@routeId,@fromCity,@toCity,@duration)";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@routeId", route.RouteID);
cmd.Parameters.AddWithValue("@fromCity", route.FromCityID);
cmd.Parameters.AddWithValue("@toCity", route.ToCityID);
cmd.Parameters.AddWithValue("@duration", route.Duration);
return(DAO.ExecuteCommand(cmd));
}
//update Route
public static bool UpdateRoute(string id, int duration)
{
string sql = "UPDATE Routes " +
" SET Duration = @duration" +
" WHERE RouteID = @id";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@duration", duration);
cmd.Parameters.AddWithValue("@id", id);
return(DAO.ExecuteCommand(cmd));
}
/// <summary>
/// update password by User
/// </summary>
/// <param name="email"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool UpdateUserPassword(string email, string password)
{
string sql = "UPDATE USERS" +
" SET Password = @password" +
" WHERE Email = @email";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@password", password);
cmd.Parameters.AddWithValue("@email", email);
return(DAO.ExecuteCommand(cmd));
}
/// <summary>
/// Add new city
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public static bool AddCity(City c)
{
string sql = "INSERT INTO Cities VALUES(@id,@name,@national)";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@id", c.CityID);
SqlParameter pName = new SqlParameter("@name", c.CityName);
pName.SqlDbType = SqlDbType.NVarChar;
pName.Size = 50;
cmd.Parameters.Add(pName);
cmd.Parameters.AddWithValue("@national", c.NationalID);
return(DAO.ExecuteCommand(cmd));
}
/// <summary>
/// add a user to db
/// </summary>
/// <param name="u">a user</param>
/// <returns></returns>
public static bool AddUser(UserInfo u)
{
string sql = "INSERT INTO Users VALUES(@email,@password,@name,@role)";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@email", u.Email);
cmd.Parameters.AddWithValue("@password", u.Password);
SqlParameter pName = new SqlParameter("@name", u.Name);
pName.SqlDbType = SqlDbType.NVarChar;
pName.Size = 50;
cmd.Parameters.Add(pName);
cmd.Parameters.AddWithValue("@role", u.Role ? 1 : 0);
return(DAO.ExecuteCommand(cmd));
}
/// <summary>
/// Update City
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public static bool UpdateCity(City c)
{
string sql = "UPDATE Cities" +
" SET CityName = @name," +
" NationalID = @nationalID" +
" WHERE CityID = @cityID";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
SqlParameter pName = new SqlParameter("@name", c.CityName);
pName.SqlDbType = SqlDbType.NVarChar;
pName.Size = 50;
cmd.Parameters.Add(pName);
cmd.Parameters.AddWithValue("@nationalID", c.NationalID);
cmd.Parameters.AddWithValue("@cityID", c.CityID);
return(DAO.ExecuteCommand(cmd));
}
/// <summary>
/// Update user by Admin
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static bool UpdateUser(UserInfo u)
{
string sql = "UPDATE USERS" +
" SET Password = @password," +
" Name = @name" +
" WHERE Email = @email";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
cmd.Parameters.AddWithValue("@password", u.Password);
SqlParameter pName = new SqlParameter("@name", u.Name);
pName.SqlDbType = SqlDbType.NVarChar;
pName.Size = 50;
cmd.Parameters.Add(pName);
cmd.Parameters.AddWithValue("@email", u.Email);
return(DAO.ExecuteCommand(cmd));
}
/// <summary>
/// Update Bus
/// </summary>
/// <param name="busID"></param>
/// <returns></returns>
public static bool UpdateBus(Bus b)
{
string sql = "UPDATE BUSES" +
" SET BusName = @name," +
" RouteID = @routeID," +
" Fare = @fare," +
" TotalSeat = @seat" +
" WHERE BusID = @id";
SqlCommand cmd = new SqlCommand(sql, DAO.Connection);
SqlParameter pName = new SqlParameter("@name", b.BusName);
pName.SqlDbType = SqlDbType.NVarChar;
pName.Size = 50;
cmd.Parameters.Add(pName);
cmd.Parameters.AddWithValue("@routeID", b.RouteID);
cmd.Parameters.AddWithValue("@fare", b.Fare);
cmd.Parameters.AddWithValue("@seat", b.TotalSeat);
cmd.Parameters.AddWithValue("@id", b.BusID);
return(DAO.ExecuteCommand(cmd));
}
