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)); }